Forum Discussion
Dynamically changing the values based dimen
I was going through this post
I need to achieve a similar kind of functionality but with dimensions than measures they have created (Total Sales, Total Cost, and Total Profit)
Is it possible to achieve this without unpivoting the columns?
Thanks,
9 Replies
Hi Anonymous ,
We still need a unrelated table as a slicer to implement dynamically filter. I did some samples that you could reference. If they are not what you want, you could share some sample data and the expected result. Then we will help you to solve it.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.
Hello,
Here is the sample data. Let me know if you can access it if not then I am not sure how to share the data? any clue?
I have Hierarchy from P1 till P15, I need to show these levels in a horizontal bar and when clicked on a particular level its related values should be seen in the table.
Something like this
In switch also, I need to create the measures but with dimensions like P1 .... P15, how is this possible?
Any help in this regard would be appreciable.
Thanks,
Hi Anonymous ,
I can't view the sample data. Please try to share it via DropBox.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.
You can create disconnected slicer using dimension and create a new measure using switch . measure=switch(true(),selectedvalue(table[column]="dimension1",measure to be displayed,...........))
