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

Hi v-piga-msft,

Please check my screen shot and update the measure.

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

    Hi Nimmi,

     

    Have you solved your problem?

     

    If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    If you still need help, please feel free to ask.

     

    Best Regards,

    Cherry