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!

SamWiseOwl's avatar
SamWiseOwl
Icon for Super User rankSuper User
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.

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

Hi SamWiseOwl ,

It was actually your video that I was watching and you're the one that responds to my message!

Where do I put the new measure? The graph and details of the measures/columns that I'm using are as follows:

 

X-Axis is a column from my date table.

Legend is a column from my Issues table.

Y-Axis is a measure:

All Faults Count - All = COUNT(Issues[Incident Date])+0

Y-Axis max is a measure from the parameter:

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)
)

 

I gave the above details to give you a bit more detail and for me to know where the new measure will slot in.

  • SamWiseOwl's avatar
    SamWiseOwl
    Icon for Super User rankSuper User
    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

      Thank you so much SamWiseOwl , that worked perfectly. I ended up using your first post and adapted that - there was a missing parenthesis somewhere but it worked after I corrected it.

      I'll check out your other videos too.

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

        Great job, DAX is scary and weird when coming from Excel. After a bit of mucking about it will click!