on 03-26-2019 6:29 AM
Hello Experts,
I have a requirement to display multiples lines for a measure based on different dimensions.
From the picture "data1.PNG" that I have uploaded. I want Date on x-Axis and want multiple lines(based on product) in line chart for price.
One line for Soap and other for Shampoo.
What I tried is-> in the picture "calculation.png" which can help me do the same.
But the issue is that Product data can be updated any time in future and I cant keep making calculated columns always.
"Output.PNG" is the desied output chart.
Is there any solution for it?
PS- Its just a dummy data.
data1.png calculation.png output.png
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Have you tried with creating two calculated measures annd than use in chart.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi amit.kumar71 ,
I have already tried it, (in picture: "calculation.PNG")
But the issue is that dimension can be updated in the future we can have more products there,
then we cannot create measure again & again for new values of dimension in future.
Thanks,
Sarthak Srivastasva
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.