Forum Discussion

PowerBI-Newbie's avatar
PowerBI-Newbie
Icon for Helper IV rankHelper IV
2 years ago
Solved

Parameter slider to remove bars higher than selected value

Hi, I have a clustered column chart and I added a parameter slider to the Y-Axis (see image below):   What I want to achieve is when the user changes the slider/value and thus the Y-Axis max...
Need Help
  • SamWiseOwl's avatar
    SamWiseOwl
    2 years ago

    Hi PowerBI-Newbie 
    Create a measure that says:
    Show or Hide measure =
    If( [SrStatusCalculation] > SelectedValue(table[srStatusSliderMax]), BLANK(), [SrStatusCalculation] )
    Use BLANK if you want the column to disappear or 0 to keep the column but show empty.

  • SamWiseOwl's avatar
    SamWiseOwl
    2 years ago

    Hi PowerBI-Newbie 

    Oh that is awesome, I will be making more videos but got side tracked by having children ๐Ÿ˜‚

     

    The measure will effectively replace the Y axis calculation, so something like this:
    If( COUNT(Issues[Incident Date]) > [MaxChart All Faults Count - All], BLANK(), COUNT(Issues[Incident Date]) )

     

    Let me know how you get on ๐Ÿ™‚

    Also if you didn't know we have full free video courses you can watch!

PowerBI-Newbie's avatar
PowerBI-Newbie
Icon for Helper IV rankHelper IV
2 years ago

Hi SamWiseOwl ,

Sorry to bother you. How do I take the user selection of certain columns into account? So still using the following measures:

Y-Axis Maximum:

All Faults Count - All Status Y-Axis = IF( ([All Faults Count - All]) > [MaxStatusSlider Value], 0, ([All Faults Count - All] ))

 

MaxStatusSlider Value (Parameter measure):

MaxStatusSlider Value = SELECTEDVALUE('MaxStatusSlider'[MaxStatusSlider], [MaxChart Overall Failure Status All Faults Count - All])

 

Fault Count Measure:

MaxChart All Faults Count - All = 
CALCULATE(
    MAXX(
        ADDCOLUMNS(DISTINCT(ALL(Issues[Year:Period],Issues[Status])),"AllCount",[All Faults Count - All]),[AllCount])*1.1,
        All(Issues)
)

 

So the user may select a particular date period or filter by category so what do I need to change within the measure(s) above to ensure the Y-Axis measure updates accordingly?

SamWiseOwl's avatar
SamWiseOwl
Icon for Super User rankSuper User
2 years ago

Hi PowerBI-Newbie the only thing I see that would be preventing it from changing is the ALL.

All removes internal AND external filters.

AllSelected only removes internal ones (external filters like slicers, filter pane, drillthrough will be kept).

Or AllExcept to remove all filters except the ones on columns you specify.