Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Pfoerster
Helper III
Helper III

Stagged Bar Chart with multiple values

Hello,

again, I am struggling at transforming an EXCEL Report into Power BI:

BarChart.JPG

I would like to create this kind of bar charts, and I have following problem:

As Legend of the Bar Chart, I choose my Territory, so I get the "Americas, Emena, APA/China"... everything fine but:

the volumes, based on the different Scenarios (ACT 19, BUD 20, SUF 20, ACT 20) are all calculated measures. Therefore, I can only put one of these 4 into the Value of the Bar Chart Visual. 

And I can not put the Scenario into the Axis of the Bar Chart, because then, I do not have the ACT 19, because in my Dataset, I only have the BUD, SUF and ACT as Element of the Scenario Column.

Is there any workaround, how I can visualize my 4 calculated Measures as a stagged bar chart, based on territory? 

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @Pfoerster ,

 

Create a disconnected table with the following data:

MFelix_0-1601031596456.png

Now create the following measure:

VALUE = SWITCH(
                SELECTEDVALUE('AXIS'[ID]); 
                1 ; [ACT 19];
                2; [BUD 20];
                3 ; [SUF 20]; 
                4; [ACT 20]
            )

 

Build you chart with the following setup:

Axis: X-Axis Column

Legend: Territory

Values: Measure Value

 

Result below and in attach PBIX file.

MFelix_1-1601031720844.png

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

2 REPLIES 2
MFelix
Super User
Super User

Hi @Pfoerster ,

 

Create a disconnected table with the following data:

MFelix_0-1601031596456.png

Now create the following measure:

VALUE = SWITCH(
                SELECTEDVALUE('AXIS'[ID]); 
                1 ; [ACT 19];
                2; [BUD 20];
                3 ; [SUF 20]; 
                4; [ACT 20]
            )

 

Build you chart with the following setup:

Axis: X-Axis Column

Legend: Territory

Values: Measure Value

 

Result below and in attach PBIX file.

MFelix_1-1601031720844.png

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Perfect! It is working as I like 🙂 Thank you very much. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.