two slicer combinations for different charts

[Nimmi]

How to write measure for a clusterd bar chart with combination of selection radio buttons from two sliers.  

[v-piga-msft]

Hi @Nimmi,

Normally, we could use SELECTEDVALUE(TableName[Table value]) to get the selected value in slicer.

More details will help us to understand your scenario better.

Are the values in your two slicers coming from different tables?

If it is convenient, could you share some data sample which could reproduce your scenario and you desired output so that we could help further on it.

Best Regards,

Cherry

[Nimmi]

Yes the values are coming from different tables for two slicers.

table 1 for select metric : Average million

             Total Million

             relative diff

             number of operations.

Table 2 for selecat breakdown : asset

              well

              operation type

From the 2 slicers we should select one from mertic and one from breakdown, So total 12 possible combinations will be applicable for chart. how can I write measure for this.

[v-piga-msft]

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]

Hi @v-piga-msft,

Please check my screen shot and update the measure.

[v-piga-msft]

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

[Nimmi]

 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 · Accepted solution]

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