Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone,
I have a requirement which would be very simple in SSRS, yet I have no idea how to implement it in Power BI.
Customer wants this kind of table/matrix output:
Account Number | Month 1 | Month 2 | ... | Month N| YTD
1234 value 1 Value 2 ... Value N | Value YTD
Months are selectable, and can be any from Jan to Dec within a single year.
There are measures for Value and Value YTD in the tabular model I am using.
Please help with how to implement this !
Thanks in advance!
Andrey
Hi @AnGorSan ,
It seems that your desired output would be achieved with table / matrix visual in Power BI.
Are Month1, Month2 ... MonthN from one single column?
If you could share your data sample as table format so that I could understand your scenario better and get the solution quickly.
Best Regards,
Cherry
Hi Cherry!
My source data is a Tabular model with transactions fact and Date, Cost Center and Account dimensions.
I have a measure for Transaction Amount, and a measure for Transaction amount YTD.
If I place these two measures into a matrix, the result is not what I am looking for:
The month value is coming from the single column in my date dimension.
For the Table visual, I will have to create a measure per month, and the structure would become rigid, as if the measure has no value, the column will still remain.
Hi @AnGorSan ,
If your desired output is like below.
I'm afraid that we cannot achieve that directly for matrix.
You need to create the two matrix like below and turn off the word warp of row header and column header, then hide the account number for the YTD matrix and then pin the two tables as a workaround.
Please have a reference of my attachment.
Best Regards,
Cherry
Hi Cherry,
Well, it seems that it is as close as you can get, but still, when the number of month is less then 12, the result looks like this:
I believe in this case the table visual with per month measures approach is best, as at least the structure would remain intact.
I will try to convince my customer to adjust the requirement to allow this.
Thank you for your effort!
Andrey
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |