Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

dashboard filter range

Hi, 

 

I made a filter on my dashboard, but the filter is not exactly how I expected. 

I want a range from 0 to 250, 250-500, 500-750.

I also create groups with a bin size equal to 250.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Can anyone help me?

 

 

Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Anonymous ,

     

    We can create a calculated column use the following formula, then put this filed into the filter.

     

     


    BTW, pbix as attached.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    We can create a calculated column use the following formula, then put this filed into the filter.

     

     


    BTW, pbix as attached.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.