Multiple columns in slicer

[Anonymous]

Hi there!

I am working on a frontpage on which I want to show things like: top 10 highest, top 10 lowest, allocation ect ect. How can I show this of several columns on one page (without showing them together)? is it possible to have a slicer that makes a selection between columns possible? These columns are not related to each other so its not a hierarchy. 

in other words a slicer or anything that makes a selection of a column possible instead of the values of each column:

A 

B

C

ect

Please let me know if you need additional info,

many many thanks!

Loek

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Based on your description, measure can achieve similar requirment, but column cannot.

Create multiple measures, create a disconnected table with the name of measure, and change measure dynamically through slicer.

Sum_sales = SUM('Table'[Sales])

Rate = 
var total_month_sales = CALCULATE(SUM('Table'[Sales]),ALLEXCEPT('Table','Table'[Month name],'Table'[Date].[Year]))
var per_product = [Sum_sales]
return DIVIDE(per_product,total_month_sales)

Measure = SWITCH(SELECTEDVALUE('Table (2)'[slicer]),
            "Rate",[Rate],
            "Sum_sales",[Sum_sales])

Here is the sample .pbix

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Not very clear

You can not show hide the columns. But you use measure slicer or bookmarks to create this kind of feel

Bookmarks

https://www.youtube.com/watch?v=z9jdkyyE3WU

measure slicer
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115

Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/

measure slicer
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115

[AllisonKennedy]

@Anonymous  Mostly DAX works on 1 column, so you might be able to unpivot the columns and get a similar result to what you're looking for.