Forum Discussion
How to show different value when is first row in Matrix
Hey all, I'm trying include in first row a dynamic value according to the filter. Like this: I used the ISINSCOPE to check if scope row is "Nivel Extra", but the total row is also out of...
Here is a sample file with that format.
Note a few things:
- Look in Power Query to see how the MMM/YY field was generated.
- Note that MMM/YY is text, but is sorted by the "MMM-YY" number field via the Modeling tab.
- See how the fields are in he Visualization, Formatting pane.
Thanks for the answer, but my column visualization is not in cronologics, follows sames rules, for exemple:
First column is the same filter month as last year;
Second column is budget of the same month filtered;
Third column is the one from the previous month filtered;
And finally the filtered month returns.
When I add the month column in the view, it brings me only the column I'm filtering. So I want to change the first row dynamically, so I can put the correct month / year value.