Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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,
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.
User | Count |
---|---|
118 | |
66 | |
65 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
67 | |
61 | |
53 |