Slicer range is lower than data

[Rolina]

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

[johnt75 · Accepted solution]

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.

[johnt75 · Accepted solution]

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.

[Rolina]

You were right actually! I've just realized that table shows cumulative numbers (as i have a few rows giving some numbers per 1 item, hence sums oper 1 item are bigger than 47, but actual number for individual row is max 47 in my data.

[Rolina]

no, it is not. I have plenty numbers above 47, that's why the issue is so major. To be honest, I don't even have 47 in my data, which is ever more concerning

[Rolina · Accepted solution]

hi All,

I found workaround for the issue and I tested it and it worked for me.

Thank you all for valuable comments!

Solved: Number Range as Slicer - Microsoft Fabric Community

[Bibiano_Geraldo]

Hi @Rolina ,

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.