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.
Hello,
I have a matrix visualization that utilizes a hierarchy. I also have a target value that changes based on the hierarchy. What DAX should I use so that the value changes in accordance with the hierarchy?
The top line visual looks like this:
Supply Chain | MTD | YTD | Target |
GSC | 76.7% | 76.7% | 75.9% |
PSM | 79.5% | 79.5% | 76.9% |
And then the drill down looks like this:
Product | Site | MTD | YTD | Target |
GSC | ||||
A | RV | 100.0% | 100.0% | 70.0% |
A | UM | 50.0% | 50.0% | 75.0% |
A | BC | 72.4% | 72.4% | 70.0% |
PSM | ||||
P | BC | 55.6% | 55.6% | 70.0% |
P | W | 47.6% | 47,6% | 70.0% |
P | I | 53.3% | 53.3% | 70.0% |
Note that the target for each supply chain has one value, and then those targets change again depending on the combination of product and site. Ideally, I'd be able to conditionally format the MTD value depending on whether it was more or less than the target.
@Anonymous , You need to consider the calculation group for the same
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |