Forum Discussion
Helper IVParameter slider to remove bars higher than selected value
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.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!
Super UserOh 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!
Helper IVThank 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
Great job, DAX is scary and weird when coming from Excel. After a bit of mucking about it will click!