Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello!
I have the table visualization shown in the screenshot below (icon column was filled in manually to represent end goal). Actual is a "Count (Distinct)" from another table and is showing value as "Percent of grand total". Budget is a measure (also shown in screenshot).
My end goal is to use conditional formatting and icons to have a red or green symbol on each row to show whether or not actual is greater than or equal to budget. I realize I need to use a measure to accomplish this. I created a measure called Icon but I can't seem to figure out how to use DAX to come up with the same thing that "Percent of grand total" is doing.
So far I have this, but I know it's not correct as the variable is giving the distinct count but not the percentage of grand total:
Icon =
VAR
Actual = DISTINCTCOUNT(view_ods_patient_census_rate_actual[BedID])
RETURN
IF(Actual >= [DisplayBudget],"1","0")
Thanks in advance for any help you can provide!
Solved! Go to Solution.
Hi @rbreneman ,
From what you described it seems you need to write the measure that will do the % of total.
Then you should be able to do your icon measure like you were trying.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
Hi @rbreneman ,
Try this measure.
Measure = IF(MAX('Table'[Acutal])>MAX('Table'[Budget]),"SignLow","CircleHigh")
To show icons based on cell values, select Conditional formatting for the field, and then select Format by Field value. Select based on Measure field.
You can check more details from here.
There is a list of icon names at the bottom of this article:
I post the list here for your reference:
Id | Name |
1 | SignLow |
2 | SignMedium |
3 | CircleHigh |
4 | CircleMedium |
5 | CircleLow |
6 | 4CircleLow |
7 | CircleMedium1 |
8 | 4CircleMedium2 |
9 | CircleEmpty |
10 | Circle25 |
11 | CircleHalf |
12 | Circle75 |
13 | CircleFilled |
14 | TrafficLow |
15 | TrafficMedium |
16 | TrafficHigh |
17 | TrafficBlackRimmed |
18 | TrafficLowLight |
19 | TrafficMediumLight |
20 | TrafficHighLight |
21 | CircleHalf |
22 | TrafficBlackRimmedLight |
23 | ColoredArrowDownRight |
24 | ColoredArrowRight |
25 | ColoredArrowUpRight |
26 | ColoredArrowUp |
27 | GreyArrowDown |
28 | GreyArrowDownRight |
29 | GreyArrowRight |
30 | GreyArrowUpRight |
31 | GreyArrowUp |
32 | FlagLow |
33 | FlagMedium |
34 | FlagHigh |
35 | FlagBlack |
36 | SymbolLow |
37 | SymbolMedium |
38 | SymbolHigh |
39 | CircleSymbolLow |
40 | CircleSymbolMedium |
41 | CircleSymbolHigh |
42 | StarLow |
43 | StarMedium |
44 | StarHigh |
45 | StarMediumLight |
46 | StarHighLight |
47 | TriangleLow |
48 | TriangleMedium |
49 | TriangleHigh |
50 | SignalBarEmpty |
51 | SignalBarLow |
52 | SignalBarMedium |
53 | SignalBarMedium2 |
54 | SignalBarFull |
55 | SignalBarLowColored |
56 | SignalBarMediumColored |
57 | SignalBarMedium2Colored |
58 | SignalBarFullColored |
59 | QuadrantEmpty |
60 | Quadrant25 |
61 | Quadrant50 |
62 | Quadrant75 |
63 | QuadrantFull |
64 | Quadrant25Colored |
65 | Quadrant50Colored |
66 | Quadrant75Colored |
67 | QuadrantFullColored |
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @rbreneman ,
From what you described it seems you need to write the measure that will do the % of total.
Then you should be able to do your icon measure like you were trying.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
Thanks! Sorry, forgot to come back and mark accepted, but this worked perfectly! Thanks again!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |