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.
Hi,
I'm checking now the new posibility of conditional formating by field https://powerbi.microsoft.com/es-es/blog/power-bi-desktop-august-2018-feature-summary/#conditionalFo... and I'm having some issues that I hope you guys can help me.
As an example, I have 3 different KPIs (PR1 KPI, PR2 KPI and PR3 KPI) that need to be related to the same condition of colors
I have used the same example as the url for this and i have written this code:
Color KPIs = SWITCH( TRUE() ,table[PR1 KPI]<0.9,"#FD625E" ,table[PR1 KPI]<0.99,"#F2C80F" ,table[PR1 KPI]>=1,"#41BF37" ,table[PR2 KPI]<0.9,"#FD625E" ,table[PR2 KPI]<0.99,"#F2C80F" ,table[PR2 KPI]>=1,"#41BF37" ,table[PR3 KPI]<0.9,"#FD625E" ,table[PR3 KPI]<0.99,"#F2C80F" ,table[PR3 KPI]>=1,"#41BF37" ,"#FFFFFF" )
Then I have created the visual table matrix with the 3 KPIs and then i have applied the conditional formating as the example in the url
The problem that I have is that the background color not take for each KPI the related color, it os something strange like the system takes the 1st color rule for each row and put the color for the next KPIs, example
if i have PR1 KPI = 94%, PR2 KPI = 98% and PR3 KPI 105% the system put 3 backrounds in red due to the first KPI in the code is the PR1 KPI and it is red in this case insted of put Red for PR1 KPI , Yellow in PR2 KPI and Green in PR3 KPI. Do you know the reason?
Is it necessary to create a Color KPI measure for each KPI that i have? it will be crazy....
Is there any possibility to modified the code of the measure Color KPI in order to can be applied in any measurement only depending the result value?
something like
But not related to any measurement, and then can we apllied for any measuremente that i want to aplly the conditional formating based on this Color KPI?
Thanks in advance, regards!
Hi @dobregon,
If you create the Color KPI only for PR1 KPI, will it work as expected?
Color KPIs = SWITCH( TRUE() ,table[PR1 KPI]<0.9,"#FD625E" ,table[PR1 KPI]<0.99,"#F2C80F" ,table[PR1 KPI]>=1,"#41BF37" ,"#FFFFFF" )
If it is convenient, could you share some data sample which could reprofuce your scenario so that we could help further on it?
Best Regards,
Cherry
Hi @v-piga-msft
Yes, if i create the Color KPI only for PR1 KPI it works fine, but in reality i have more than 20 measurements KPI that need to have the same conditional formating. So, if i need to create 20 Color KPI measurements.... it will be crazy. For that i'm asking if i can create a color KPI measurement that apply for whatever measurement only checking if the results of the measuremetns <90, >95 and >1
Regards
Hi, any progress, solution or workaround found on this issue?
I'm trying to solve the same issue here.
thank you
marco
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |