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.
About:
Above is a snap shot of a report in a pivot table (Excel) that is one of two main reports at my firm. The conditional formatting is based on another tables value. {Green for value less than 0.75; Yellow between 0.75 & 1.00, Red for greater than 1.00}. The {0.75, 1.00} values are not absolute values, but values that change overtime and are stored in another table.
Question:
My question is whether or not this can be done in Power BI in some capacity?
Additional Info:
I know the conditional formatting does not exist...yet... in Power BI; would it be possible in a measure?
Kindly,
James
Solved! Go to Solution.
Hey,
in someway there is some kind of conditional formatting, but unfortunately not in a way to answer your requirement, for this reaon I use some kind of measure that is responsible for the column Light
The measure utilizes the capabilities of the "mystic" function UNICHAR 🙂 and looks like this
Light = UNICHAR(if(AND([Amount PY] >= 0, [Amount PY] < 140), 128213, if(AND([Amount PY] >= 140, [Amount PY] < 200), 128210, 128215)))
From a usability point of view, this is much less than can "easily" achieved in EXCEL but the degree of freedom is beyond, besides the aspect that you have to use your own column.
Hope this gives you an idea
Regards
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |