Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I would like to ask you for advise if it is possible to filter only items that have minus in matrix? im interested in only those where minus will appear (in any week).
what i have:
and this is what im expecting to have:
The calculation in matrix is a measure showing stock level in each week, so if i just filter with a measure then i will get only items where total of measure is below 0 it will not check week by week. Many thanks for any suggestions.
Solved! Go to Solution.
Hi @mhsk ,
Create a new measure as below to work on it.
Measure 2 = IF([Measure]>=0,BLANK(),[Measure])
Put a visual level filter on the measure [Measure]>0
This is a bit different scenario. please put your measure as value, weeks as column and any other dimention that measure impacts (part, etc) in row. Thing is measure filter will work for total measure value <0 and im looking for to see measure values <0 for each week / each part.
So to cut the long story short im just looking to see all items (rows) where measure was <0 at any week (like on this picture):
when there was an event = measure<0 it is coloured in red and i just want to see items impacted by red. doable?
Hi @mhsk ,
Create a new measure as below to work on it.
Measure 2 = IF([Measure]>=0,BLANK(),[Measure])
Thanks for your help!
This is not actually 100% an accurate solution. As you can see, the total of the matrix is blank as well. The positive values had been hidden, but not removed from the calculation.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |