Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi community,
I have a table visual in a report I am working on showing target values and actual values for different categories and locations. So for the target table where I have the data for targets per location and category I have:
Location | Category | Lines | Target |
Sweden | Drilling | 1 | 2 |
Sweden | Milling | 2 | 2 |
Sweden | Turning | 2 | 6 |
Denmark | Drilling | 2 | 4 |
Denmark | Milling | 1 | 1 |
Denmark | Turning | 2 | 6 |
And from a database I get the actual figures as in this example:
Location | Category | Month | Actual |
Sweden | Drilling | aug | 2 |
Sweden | Milling | aug | 8 |
Sweden | Turning | aug | 11 |
Denmark | Drilling | aug | 4 |
Denmark | Milling | sep | 7 |
So the database will keep building of course with more data for every month. I get the data in the visual table all well but when I filter per month I want the "actual" column in the visual to turn red if above target and green if below or equal to target. The resulting table should look like this when filtered:
Location | Category | month | Target | Actual |
Sweden | Drilling | aug | 2 | 2 |
Sweden | Milling | aug | 2 | 8 |
Sweden | Turning | aug | 6 | 11 |
Denmark | Drilling | aug | 4 | 4 |
So the numbers are all correct but how to make a "dynamic" calculation like this for, I am assuming, conditional formatting? I am stuck to how to achieve this and any help would be much appreciated.
Regards,
Maud
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |