Forum Discussion
Power BI Table In the UI
Here's a pbi file that does most of what you are looking for, Mtozero.
Sadly, it looks like my post where I explained how this works is in moderation....
Short version:
- disconnected table to setup the context for the report with a couple of calculated columns.
- -11 to 0 rows are individual months
- 1 is Trailing Twelve Months; 2 is Trailing Twelve Months last year; 3 is Variance.
- Variance is the tricky one because it doesn't have just a start and end date.
Measures to get the appropriate amounts.
Create a matrix visualization with Range field from the Report table on Columns.
States or in my case countries on rows.
Put the final measure on as values.
Turn off subtotals and grand totals for rows.
Keep grand totals for columns.
Conditional formatting options are limited right now.
Thanks, freder1ck, Appreciate your quick response.
Do we have any options to dynamically change the column Name of the table?
Thank you!
When you say dynamically change the name of the column name, what exactly do you mean?
The column names of the Report table are set when the data is refreshed.
The current month (offset value 0) is 12/31/2017. In a few days, the current month will be 1/31/2018.
It looks like I put the wrong link in to my personal OneDrive. I'll put the link up after work today.
Fred
thanks freder1ck for your response. Appreciate your support.
My problem is with the disconnected table since we need to more slicers.
So what I was thinking let's assume there is no disconnected table. If I can add 12 measures (DAX for each month). It might work but the problem is how to make the measure name/column name dynamically changing.