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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
TimoMeyer
Frequent Visitor

Stacked Column Chart - Show only filtered values as column

Dear all, 

 

I have a column chart that is clustered by different plants. When I select one plant I only want to see the value for that plant as the column. Right now when I select a plant the part of the column that belongs to that plant is highlighted. Is there a setting that I can apply, that I dont see the plant as a partion of the total but really only the value of the plant as the column. Please find the screenshots for reference.

 

How it is looking right now (before applying filter):

TimoMeyer_0-1677151795043.png

 

How it is looking right now (after applying filter):

TimoMeyer_1-1677151858223.png

 

How I want it to look like (after applying the filter):

TimoMeyer_2-1677151912793.png

(only got to this view by removing the plant from the legend, but I want to achieve it without having to remove the plant)

 

 

 

2 REPLIES 2
Uspace87
Resolver III
Resolver III

@TimoMeyer 

 

I have tried with the "Stacked column chart" and it works fine:

 

Uspace87_0-1677153199656.png

 

 

Uspace87_1-1677153216680.pngUspace87_2-1677153238278.png

 

Thanks for the reply. Did you change any settings?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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