Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hey all,
I'm trying include in first row a dynamic value according to the filter. Like this: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" scopeAs it was.
I want now a way to show different value when is first row in Matrix
Thanks and sorry for my english.
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingI 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:
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThanks 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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
144 | |
73 | |
64 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |