Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi
I have simplified my matrix table to the below.
Am I able to apply conditional formatting to the Variance section only? I want values to show as red for a negative variance and green for a positive variance. I can't find anything online that suggests you can.
Thanks
A
Solved! Go to Solution.
Hello @AlexChitan,
As there is no straightforward solution to your problem, I have tried a workaround solution and it works well.
I tried to apply conditional formatting to cell using measure, where we can specify our "Variance" section condition effectively.
Hello,
I need help about matrix column totals.
I would like to have these kind of view but I can not view column total for each month .
gross sales, domestic sales... are measures on rows.
do you have an idea?
thanks
Hello @AlexChitan,
As there is no straightforward solution to your problem, I have tried a workaround solution and it works well.
I tried to apply conditional formatting to cell using measure, where we can specify our "Variance" section condition effectively.
Amazing this has worked. Thank you!
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |