Forum Discussion
Slicer range is lower than data
hi, I built dashboard that shows different velues (between 0 and 70). I need slicer to enable possibility for the user to pick numbers beetween 30 and 70. It works when I put numbers manually into fileds, however slicer "forces" to put maximum range to 47 only
I can change it manually to e.g. 100, but when i clear slicer and start using it from the beggining, it provides 47 again. How can I pernamently change 47 into higher number?
I am not familiar with DAX.
Thanks
The slicer will only show values which exist in the data, so I would guess that the max value in your data is 47.
If you want to ensure a consistent user experience with the same max and min numbers each time, regardless of the data, you could create a new numeric range parameter. Link the Parameter column to your fact table in a one-to-many single direction relationship and your report will only show values within the range selected by the user.
hi All,
I found workaround for the issue and I tested it and it worked for me.
Thank you all for valuable comments!
5 Replies
The slicer will only show values which exist in the data, so I would guess that the max value in your data is 47.
If you want to ensure a consistent user experience with the same max and min numbers each time, regardless of the data, you could create a new numeric range parameter. Link the Parameter column to your fact table in a one-to-many single direction relationship and your report will only show values within the range selected by the user.
hi All,
I found workaround for the issue and I tested it and it worked for me.
Thank you all for valuable comments!
Hi Anonymous ,
Can you please share a no sensitive file to see this closer? please upload your no sensitive file to onedrive or other cloud service and share the link for download here.
