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.
hello everyone!
i have created a cohort in power bi in a matrix visual and im trying to change the values backgroundcolor using the conditional formating however im unable to get my intended output
this is the output im getting:
i want to to exculude color from first column with a title '0' which only have '100%' value, so backgroundcolor should appear starting from column 1 and i want the color rule to apply to rows instead of columns . so for a specific month , i want to see the color changing between the values from 1 to 20 according to the values for that month .
thanks in advance
Solved! Go to Solution.
@lawada
I created a sample file with my data and tried to answer your question. To apply CF across columns by row, you need to create a measure that ranks the values across columns and excludes the unnecessary column: Please check the measure below. File attached below
CF Rank =
IF(
MAX(financials[Month Number])<>1,
CALCULATE(
RANKX(
ALLSELECTED( financials[Month Number] ),
[Total Units]
),
KEEPFILTERS( financials[Month Number] <> 1 )
)
)
When you apply conditional formatting, choose Don't Format under default Formatting
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@lawada
I created a sample file with my data and tried to answer your question. To apply CF across columns by row, you need to create a measure that ranks the values across columns and excludes the unnecessary column: Please check the measure below. File attached below
CF Rank =
IF(
MAX(financials[Month Number])<>1,
CALCULATE(
RANKX(
ALLSELECTED( financials[Month Number] ),
[Total Units]
),
KEEPFILTERS( financials[Month Number] <> 1 )
)
)
When you apply conditional formatting, choose Don't Format under default Formatting
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
working perceftly. thank you !
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |