Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 !
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |