Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AnndreyMacedo
Frequent Visitor

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:
As I wish.As I wish.

 

I used the ISINSCOPE to check if scope row is "Nivel Extra", but the total row is also out of "Nivel Extra" scope
As it was.As it was.
I want now a way to show different value when is first row in Matrix


Thanks and sorry for my english.

4 REPLIES 4
edhans
Super User
Super User

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.

 

image.png



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

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

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.

image.png



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

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.
image3.PNG

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.