Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Im trying to create a range where value is "Less than 50", "More than 50" and "More than 150". I was able to achieve this but I want values that are more than 50 to display inclusive of values more than 150 as well. User should have an option to only to view all data that are more than 50 and if they want to view values more than 150 they should be able to select that.
Range = SWITCH( TRUE(), 'All'[Value (USD)] < 50, "Less than 50", 'All'[Value (USD)] > 50 && 'All'[Value (USD)] < 150 , "More than 50", 'All'[Value (USD)] > 150, "More than 150")
This code will segregate data with value 50 and 150. I would like to know if its possible to display data that are more than 50 & 150 when user select "More than 50". If user selects more than 150 then it will only display data with value more than 150.
I hope someone could give a suggestion for this 🙂
Solved! Go to Solution.
Hi @Anonymous
you can create or import a separate disconnected table that contains the three text descriptions of the three rangges let's call it 'Ranges' that contains one column [Range]. Inserr a sclicer based on 'Ranges[Range]. Place the following measure in the filter pane of the visual, select "is not blank" and apply the filter
Range =
SWITCH (
SELECTEDVALUE ( Ranges[Range] ),
"Less than 50", COUNTROWS ( FILTER ( 'All', 'All'[Value (USD)] < 50 ) ),
"More than 50", COUNTROWS ( FILTER ( 'All', 'All'[Value (USD)] > 50 ) ),
"More than 150", COUNTROWS ( FILTER ( 'All', 'All'[Value (USD)] > 150 ) )
)
Hi its alright I made it work, thank you for your input 🙂
Its an empty table when i create a table using this measure. When I use it as a slicer for my existing dashboard it only shows More than 150.
Hi @Anonymous
you can create or import a separate disconnected table that contains the three text descriptions of the three rangges let's call it 'Ranges' that contains one column [Range]. Inserr a sclicer based on 'Ranges[Range]. Place the following measure in the filter pane of the visual, select "is not blank" and apply the filter
Range =
SWITCH (
SELECTEDVALUE ( Ranges[Range] ),
"Less than 50", COUNTROWS ( FILTER ( 'All', 'All'[Value (USD)] < 50 ) ),
"More than 50", COUNTROWS ( FILTER ( 'All', 'All'[Value (USD)] > 50 ) ),
"More than 150", COUNTROWS ( FILTER ( 'All', 'All'[Value (USD)] > 150 ) )
)
Hi @tamerj1 ,
Ive tried the suggested method but it only displays "More than 150" even when all 3 ranges are in table.
@Anonymous
Would you please share a screenshot of what you've achieved so far?
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |