Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have the data like below,
I would like add a slicer showing Price and Percentage , Based on the selection from slicer col from table/Matrix should hide / show ... lets say i have selected Price then expected output is like below. ( I am able to acheive like values are hiding/showing based on my selection but not like below)
I am able to achieve like below if selection is on price from slicer but pecentage col should hide.
Solved! Go to Solution.
Hi @Mani1205 ,
Go to query editor>select column "Percentage" and "Price",choose "unpivot the columns";
Then create a slicer table as below:
Slicer = DISTINCT('Table (2)'[Category])
And a measure as below;
Measure 2 = IF(ISFILTERED('Slicer'[Category]),CALCULATE(MAX('Table (2)'[Value]),FILTER('Table (2)','Table (2)'[Category]=SELECTEDVALUE(Slicer[Category]))),MAX('Table (2)'[Value]))
And you will see:
For the related .pbix file,pls click here.
Would the above slicer work around still work if there was data from two separate queries in the table and measures in the table also?
Hi @Mani1205 ,
Go to query editor>select column "Percentage" and "Price",choose "unpivot the columns";
Then create a slicer table as below:
Slicer = DISTINCT('Table (2)'[Category])
And a measure as below;
Measure 2 = IF(ISFILTERED('Slicer'[Category]),CALCULATE(MAX('Table (2)'[Value]),FILTER('Table (2)','Table (2)'[Category]=SELECTEDVALUE(Slicer[Category]))),MAX('Table (2)'[Value]))
And you will see:
For the related .pbix file,pls click here.
@Mani1205 , for show hide you might have use bookmark.
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
There is another option but it replaces the value in existing column
Hi
Try below
Showvalue =
SWITCH (
TRUE (),
SELECTEDVALUE ( slicer[column] ) = "Price", [PriceMeasure],
SELECTEDVALUE ( slicer[column] ) = "Percentage", [PercentageMeasure],
BLANK ()
)
Thanks,
Venkata Nalla
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |