Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Multiple columns in slicer

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

 

 

Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    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.

3 Replies