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 t...
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.

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
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.