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.
Hi All,
I am trying to do a matrix as in the picture below, but within each month I would like to include columns that distinguish version (Outlook or Actual values). For instance I want to see all row values for January with the two values (Outlook & Actual) for my two different versions. At the same time, when I drill up, I would like to see the same for each Quarter. Is it possible to do so?
Many thanks in advance,
Regards
Estefania
Solved! Go to Solution.
Hi @estefaniamc,
Use Matrix table and then drop your fields as follows:
Hope this solves your issue.
Regards
Abduvali
Hi @estefaniamc,
Yes. It's available to create such a Matrix.
Add date hierarchy into column section, remove "Year" and "Day" values.
By default, the top group level is Quarter. To drill down to Month level, click the second "Drill Down" icon.
To show both Quarter and Month level as column header, you could click the third "Drill Down" icon.
Best regards,
Yuliana Gu
Thanks for your contribution, it helped resolve my issue as well 🙂
Hi All,
Is it possible to create the matrix demonstrated, but instead of the [Actual] and [Outlook] columns existing per quarter, have the quarters exist per each of those value headings.
So, instead of having Option 1, you would have Option 2 (both below).
Thanks
Shane
Thanks for your suggestion @shanelthiggs but the problem comes when I tried to calculate the difference between actual and outlook per Region.
I managed to calculate it by creating new columns and add some measures that can be filtered through different supporting tables that I created.
Regards,
Estefania
Hi @estefaniamc - apologies, I was more tagging on to your original question in the hope of finding one myself; not much of a solution I know.
My desired format (Option 2 in my image) is something we can do on an existing SSAS product but can't seem to replicate that format in Power BI. The below images are what we would have in our existing product; its' effectively making the measures' headings primary, and the dimensions' headers secondary.
Hope that clarifies a little more what I was after.
Cheers
Shane
Hi @estefaniamc,
Yes. It's available to create such a Matrix.
Add date hierarchy into column section, remove "Year" and "Day" values.
By default, the top group level is Quarter. To drill down to Month level, click the second "Drill Down" icon.
To show both Quarter and Month level as column header, you could click the third "Drill Down" icon.
Best regards,
Yuliana Gu
Hi @estefaniamc,
Use Matrix table and then drop your fields as follows:
Hope this solves your issue.
Regards
Abduvali
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 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |