Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    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's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

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]))

 

Ragasri's avatar
Ragasri
New Member
3 years ago

Hi,

I tried the same solution but i'm facing circular dependency error while making a relationship with the tables created. I'm new to powerbi and need help