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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.