The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
See Data here: https://docs.google.com/spreadsheets/d/1mOAo4i0i1-Q4WqyvltyytXzOCEIdhmOq/edit?usp=sharing&ouid=11155...
Profile Master as you see has sets of values based on the Profile selected, but Profile is a drop down selection. I thought about conditional formatting on the values for each type (tamperhump, etc), but they change based on Profile.
I want to show colors based on that.... so based on Profile - the colors would be red/gree
color2 =
SWITCH (
TRUE (),
SELECTEDVALUE ( 'Profile Master'[Title] ) = "Transcend 2.0 Trop 1x5.5 GR"
&& SUM('Quality Check'[WidthTop]) >5.600
&& SUM('Quality Check'[WidthTop]) <5.535, "red",
SELECTEDVALUE ( 'Profile Master'[Title] ) = "Transcend 2.0 Trop 1x5.5 GR"
&& SUM('Quality Check'[WidthTop]) >5.595
&& SUM('Quality Check'[WidthTop]) <5.600, "yellow",
SELECTEDVALUE ( 'Profile Master'[Title] ) = "Transcend 2.0 Trop 1x5.5 GR"
&& SUM('Quality Check'[WidthTop]) >5.535
&& SUM('Quality Check'[WidthTop]) <5.540, "yellow",
SELECTEDVALUE ( 'Profile Master'[Title] ) = "Transcend 2.0 Trop 1x5.5 GR"
&& SUM('Quality Check'[WidthTop]) >5.587
&& SUM('Quality Check'[WidthTop]) <5.549, "white",
"#FF0000"
)
I believe this will work but I do not know how to apply it, I will have to build this for EACH profile name, but how to set it as a conditional format?
Hi @Sonia316 ,
For this you need to create a calculation based on the values of the profiles and on the maximum and minimums, for each of the metrics.
Can you please confirm that the names on the colours are the ones corresponding to the columns names on the page Quality Check?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsI created this measure for one -
Transcend 2.0 Trop 1 X 5.5 GR | > 5.600 | 5.595 to 5.600 | 5.594 to 5.541 |
< 5.535 | 5.535 to 5.540 |
Thanks @MFelix - I could use all the help possible.
The JSON I am using in SharePoint looks like this - red, yellow, no color.
The values are kept in another table called Profile Master. Using WidthTop and Width Bottom would have the same code.
Their colums are as you see below - there are 4, WidthA being Red, Width B&C are yellow, and WidthD is plain.
"background-color": "=if(@currentField == '', 'rgba(0, 0, 0, 0.3)', if(@currentField < [$Profile_x003a_IRVWidthA], 'rgba(240, 52, 52, 1)', if(@currentField <= [$Profile_x003a_IRVWidthB], 'rgba(255, 255, 126, 1)', if(@currentField < [$Profile_x003a_IRVWidthC], 'rgba(255, 255, 255, 1)', if(@currentField <= [$Profile_x003a_IRVWidthD], 'rgba(255, 255, 126, 1)', 'rgba(240, 52, 52, 1)')))))"
},
I am new to PowerBi and I've been struggling for over a week. I was hoping to get this report done for this Sprint.
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 |
---|---|
135 | |
114 | |
108 | |
71 | |
57 |
User | Count |
---|---|
240 | |
129 | |
122 | |
96 | |
94 |