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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
mcflurry
Helper I
Helper I

Single stacked bar from column filtering content

Hello everyone,

I'm starting to use this and would like to create a stacked bar but am completely lost.

I have this column:

 

mcflurry_0-1619703614676.png

And I would like to create a single stacked bar that count everything that contains "linux", contains "windows", and doesn't contains windows nor linux:

 

mcflurry_1-1619703808891.png

How can i achieve this? I've been trying quick measures for hours without success.

 

3 REPLIES 3
PoojaDarbhe
Resolver I
Resolver I

Hi @mcflurry ,

 

Please try the below dax to create a column

 

testCol = IF(CONTAINSSTRING(Test[OS], "LINUX"), "LINUX", IF(CONTAINSSTRING(Test[OS], "WINDOWS"), "WINDOWS", "Other"))
 
Now pull this column in legend field of stacked bar chart and on values pull the same field having count of the same.
 
This will give you the expected result.
Let me know in case you need more clarification.
 
Best regards,
Pooja Darbhe

Great, it works.

A few more adjustments.

Can I change order of values in bar?

And can i ignore some values containing some string in any of the 3 filtered strings?

Very happy to hear that @mcflurry.

You can filter the values in filter pane, it will work as expected.

And from sort you can sort the values.

Let me know in case you need more information.

 

It will be Great if you accept the Solution. Thanks alot.

 

Best regards,

Pooja Darbhe

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors