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.
Hello! I was hoping I could ask for help on a query issue I have ran up against.
I have the attached pbix file and a BU TYPE 2 column that I am trying to pull in the area from a different table. Long story short I am trying to get the 2 visuals below to have matching totals across each month. One is for BU Type and the other even though it is titled BU Type 2 it is really AREA. Essentially I need my bottom graph to match the top one except using the EA, FA, Other or blank options.
I would love to get my BU2 or my BU Type 2 fields to wor correctly and match from a total perspective with the top chart. Any help would be amazing. The pbix file is below.
https://drive.google.com/file/d/1PvVODz4RZ6NyihKiVK32WkPUE_ysIiOo/view?usp=sharing
Hi
I'm afraid it is not possible to make your bottom graph to match the top one except using the EA, FA, Other or blank options.
Using lookupvalue funtion to get BU and BU TYPE 2 column, but they can't match each other, so when you use them to generate monthly values, the values can't be the same.
Best Regards
Maggie
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |