cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vsharma030 Frequent Visitor
Frequent Visitor

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 column (value duplicate). Same I have done for slicer and duplicated it.

The requirement is that in a clustered bar chart, I want one bar A should respond to slicer A and bar B to slicer B.
So that I can compare two bars (values, duplicate value ) one in "New" and other in "old" for same Place(axis) )

The output I am getting: - 

 

If the value selected in both slicers is same then only I am getting value. If I select New in slicer A and Old in Slicer B then clustered bar chart becomes blank. (for obvious reasons as both slicers have interaction activated with clustered bar chart) (Interaction between the slicer is disabled)


I have tried making all possible calculated columns and measure.
And came to conclusions that it is not doable in power bi (might be I am wrong).

I have tried duplicating the data source as well and using one slicer from each data source, still didn't get the desired output.

Currently, 
I can make two different horizontal graphs instead of creating one clustered bar chart.

Kindly help me or guide me in some direction. 

Data.JPGGraphical Rep.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Make Clustered Chart with Two Slicer

Hi @vsharma030 ,

 

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.

 

2.PNG

 

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

Capture.PNG

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Make Clustered Chart with Two Slicer

Hi @vsharma030 ,

 

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.

 

2.PNG

 

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

Capture.PNG

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

vsharma030 Frequent Visitor
Frequent Visitor

Re: Make Clustered Chart with Two Slicer

Thank You @v-frfei-msft  for the swift and accurate solution. 
Well, I learned something new today thanks to you. 

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,780)