Show / Hide column based on condition or slicer

[Anonymous]

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.

[StuBee123]

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? 

[Anonymous · Accepted solution]

Hi  @Anonymous ,

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.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Anonymous , 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

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115

[nvprasad]

Hi 

Try below 

Showvalue =
SWITCH (
TRUE (),
SELECTEDVALUE ( slicer[column] ) = "Price", [PriceMeasure],
SELECTEDVALUE ( slicer[column] ) = "Percentage", [PercentageMeasure],
BLANK ()
)

Thanks,

Venkata Nalla

[mac_oc]

@nvprasad 

I applied the same logic but is returning blank, any idea why ?

Thanks,

mac