Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I'm using a measure to color the total label but for some reason it's not working for the stacked coloumn chart.
I know that my measure is working fine from the tables but for some reason it's not working for total labels.
Where am I going wrong?
For other people who had a similar problem, I found a way to solve it.
I have a stacked graph of charges divided by categories and for an unknwon and bizarre reason the formatting of total labels is based on the top column of the stacked column so only one category and not the total.
To bypass this, I created a measure CALCULATE([charges], ALLEXCEPT( list of filters I need BUT categories)) and I base my formatting on this new measure that is not affected by categories.
HI @Gerri,
When you use table and matrix visuals, conditional formatting works on the detail levels and they did not apply to the total level.
For the stacked column chart, the conditional color formatting only worked when you do not use table columns on the legend fields.
Regards,
Xiaoxin Sheng
@Gerri , the Color on the label is based on grand total value. That is the reason
How should I edit the measure to split it over the months?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
87 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |