Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello everyone,
im currently working in PowerBI and trying to solve a little problem...
Im Working in a Table Called "Lieferantenübersicht" in which are a lot of Columns. Now i just want to show the lines which include the Numers 1 to 5 (Column Name "Rating")
--> I want to show the lowest 5 suppliers out of 30 suppliers in a Table. I already rated every one and gave him a rating between 1 (bad) and 30 (very good)
How do i fix the Problem? I would like to use a measure and not a visual filter
Solved! Go to Solution.
@Anonymous Well, you could do this:
Measure =
VAR __Ranking = MAX('Table'[Ranking])
VAR __Result = IF(__Ranking < 6, " ", BLANK())
RETURN
__Result
Bottom line, if you don't want a visual filter involved at all (not sure why not since a top N filter would do this marvelously) then you have to have a measure that returns *something* for the cases you want to show and otherwise return BLANK(). If you put the supplier name in a table along with this measure then only the rows that return *something* will show.
@Anonymous Maybe:
Measure =
VAR __Ranking = MAX('Table'[Ranking])
VAR __Result = IF(__Ranking < 6, "Bad", BLANK())
RETURN
__Result
@Greg_Deckler
Thank you, but i dont want to show "bad" in Table. I just want to Show the suppliers with the rating 1-5 in the Table. The other 25 suppliers should not be seen in the Table after the measure
@Anonymous Well, you could do this:
Measure =
VAR __Ranking = MAX('Table'[Ranking])
VAR __Result = IF(__Ranking < 6, " ", BLANK())
RETURN
__Result
Bottom line, if you don't want a visual filter involved at all (not sure why not since a top N filter would do this marvelously) then you have to have a measure that returns *something* for the cases you want to show and otherwise return BLANK(). If you put the supplier name in a table along with this measure then only the rows that return *something* will show.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
87 | |
84 | |
66 | |
49 |
User | Count |
---|---|
131 | |
110 | |
96 | |
70 | |
67 |