How to show different value when is first row in Matrix

Question

Hey all,I'm trying include in first row a dynamic value&nbsp;according to the filter. Like this:As I wish.&nbsp;I used the ISINSCOPE to check if scope row is "Nivel Extra", but&nbsp;the total row is also out of "Nivel Extra" scopeAs it was.I want now a way to&nbsp;show different value when is first row in MatrixThanks and sorry for my english.

edhans · Answer

Those dates (Fev/19, Fev/18) need to be in the ROWS section of the matrix visual, not the values section.

My data isn't the same as yours, but you can see i have two rows at the top of my matrix, the data type, and my date, which is MMM/YY.

edhans · Answer

Here is a sample file with that format.&nbsp;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.

anndreymacedo · Answer

I want exactly that, but how did you do it?You can make a pbix sample available. Please.

anndreymacedo · Answer

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.

Forum Discussion

How to show different value when is first row in Matrix

4 Replies

Related content

Date Different return wrong value

PowerBI - Matrix table, hide values used only for a visual calculation

Handle AverageX on different granularities matrix drilldown

Tooltip showing same values across different measures in Matrix visual

Matrix Show Different Hierarchy Levels