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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Change the transparency level of one bar in a stacked bar chart where year = 2022

Hi, 

 

I have a stacked bar chart (attached). I am looking to make the bar where year=22 a lighter color to indicate that we do not have full year data for that year. However, I am not able to find any documentation online on how to do this. 

 

Thanks, 

 

 

stacked.jpeg

1 REPLY 1
jsaunders_zero9
Responsive Resident
Responsive Resident

To do this I have created 2 measures for each gender filtering on the current year - History and Current Year. This will allow you to produce the below example.

 

If you have a file with sample data I can mock it up for you so you can see how to acheive it in your data.

 

jsaunders_zero9_0-1661391927952.png

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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