Forum Discussion
Make Clustered Chart with Two Slicer
Hi, I am trying to make a clustered bar chart in Power BI. The situation is described as below : I have a column "Value" which stores numeric value and I created another duplicate of this colum...
Hi Anonymous ,
Please check the following steps as below.
1. Create calculated tables as below.
D S = VALUES(Table1[Slicer Duplicate])
S A = VALUES(Table1[Slicer A])
2. Create relatioship between tables.
3. After that, we can create two measures to achieve our goal.
Measure = CALCULATE(SUM(Table1[value]),USERELATIONSHIP('S A'[Slicer A],Table1[Slicer A]))Measure 2 = CALCULATE(SUM(Table1[value]),USERELATIONSHIP('D S'[Slicer Duplicate],Table1[Slicer Duplicate]))
v-frfei-msft
Community Support
Community SupportHi Anonymous ,
Please check the following steps as below.
1. Create calculated tables as below.
D S = VALUES(Table1[Slicer Duplicate])
S A = VALUES(Table1[Slicer A])
2. Create relatioship between tables.
3. After that, we can create two measures to achieve our goal.
Measure = CALCULATE(SUM(Table1[value]),USERELATIONSHIP('S A'[Slicer A],Table1[Slicer A]))
Measure 2 = CALCULATE(SUM(Table1[value]),USERELATIONSHIP('D S'[Slicer Duplicate],Table1[Slicer Duplicate]))
Thank You v-frfei-msft for the swift and accurate solution.
Well, I learned something new today thanks to you.