Forum Discussion

Nimmi's avatar
Nimmi
Frequent Visitor
7 years ago
Solved

two slicer combinations for different charts

How to write measure for a clusterd bar chart with combination of selection radio buttons from two sliers.  
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Nimmi,

     

    I have made a sample to reproduce your scenario.

     

    If I understand your requirement correctly that you want to get the output below.

     

    If it is, you could modify your formula based on my measure.

     

    If I misunderstoond, please share your desired output.

     

    Best Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Nimmi,

 

Do you want to achieve the output like below?

 

 

If it is, please create the measure with the formula below.

 

Measure = 
CALCULATE (
 SELECTEDVALUE ( Breakdown[breakdown] ) & " && "
 & CALCULATE ( SELECTEDVALUE ( Matirc[metric] ) )
)

If you still need help, please share your desired output so that we could help further on it.

 

Best Regards,

Cherry

Nimmi's avatar
Nimmi
Frequent Visitor
7 years ago

 here

Here I have written measure for select metric, I need to add select breakdown options also. It is combination of two slicers.

How can I add select Breakdown options to switch ?

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi Nimmi,

     

    I have made a sample to reproduce your scenario.

     

    If I understand your requirement correctly that you want to get the output below.

     

    If it is, you could modify your formula based on my measure.

     

    If I misunderstoond, please share your desired output.

     

    Best Regards,

    Cherry