Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm trying to create a table/matrix visual where given data, I add a column that is MoM comparison, but only for the last month.
Given a Dummy table, I'd like my visual to present like that in April:
Dummy table in April:
The month before, upon no data of April, the visual would look like below:
I am able to create MoM measure for all months, and even only for the latest month, using methods similar to presented here.
The problem is that when I use that as a measure, in the best case, I can only get an empty MoM column for previous months. The goal is to have MoM column only at the end, and only for the most recent period.
Solved! Go to Solution.
@pkalisz The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
Hello Ashish - can you please show the measure or how you did this? Your PBI file is no longer available to access and this would be very helpful for me. Thank you!
Hi,
I do not have the file. Share some data, explain the question and show the expected result.
The data I would share would be very similar to the data originally posted by pkalisz:
I'm trying to create a table/matrix visual where given data, I add a column that is MoM comparison, but only for the last month.
Given a Dummy table, I'd like my visual to present like that in April:
Dummy table in April:
The problem is that when I use that as a measure, in the best case, I can only get an empty MoM column for previous months. The goal is to have MoM column only at the end, and only for the most recent period.
I'm also using a slicer to display date columns from a calendar table joined to my data. With this DAX - I am able to show MoM for last (2) months if ONLY those two months are filtered for matrix. BUT if I expand the slicer to include a 3rd month, the calculation is off:
This one is super easy and intuitive. Thank you so much.
You are welcome.
@pkalisz The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community
Wow, that's a great and fast response, thank you!
Can I do custom hierarchy dynamically, so it doesn't need a manual update?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |