Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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.
User | Count |
---|---|
84 | |
76 | |
74 | |
48 | |
39 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |