The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
137 | |
106 | |
103 | |
73 | |
59 |
User | Count |
---|---|
266 | |
127 | |
119 | |
100 | |
86 |