cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Dynamic Slicer which has range from a Measure

Hi,

 

I have Name, Country, Sales column and data for two quarters. The second quarter actually contain addition from the first column.

So i created a measure to calculate Second quarter  - first quarter.

Since measure cannot be used as a slicer, i created a whatifparameter and referred the measure value.

The problem comes that the whatifparameter series i created , i used a value from -20,000,000 to 200,000,000 and gave an interval of 10,000. I created the range in the generateseries after looking at the minimum and maximum values myself which doesn't seem to be a good solution. 

Is there any way to somehow generateseries which takes in min and max values of the measure because right now it asks for value of column and not a measure. 

 

Any help will be appreciated.

2 REPLIES 2
parry2k
Super User
Super User

@Anonymous create a new measure to filter the slicer in the range and then use it as a visual level filter:

 

Filter Whatif = 
VAR __maxValue = MAX ( WhatIf[Column] )
RETURN
IF ( __maxValue >= [Min Measure Value] && __maxValue <= [Max Measure Value], 1, 0 )

 

Use this Filter WhatIf measure as a visual level filter where value = 1 and now your selection will be within the range of minimum and maximum measure value.

 

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Anonymous
Not applicable

How do i get the minimum and maximum value from a measure since Min & Max works with column and not measure?

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors