Forum Discussion

Cathryn's avatar
Cathryn
Icon for Helper III rankHelper III
9 years ago
Solved

filters

Hi All -   I have been searching for an answer everywhere but I can't find it.     I have a page level filter that is a number value and I can't get it to display in ascending order.   All my num...
Need Help
  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    9 years ago

    A slicer is used to create an interactive experience for a consumer of the report.  A page level (or visual or report level) filter COULD be used for the same purpose, but is more intended to exclude the relevant data from the page/visual/report.  If you want to have interactivity, use a slicer.  When you publish to PowerBI.com, the end consumer may not have access to the page level filtering.

dkay84_PowerBI's avatar
dkay84_PowerBI
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

And please indicate what the data type is for the field in question. 

dkay84_PowerBI's avatar
dkay84_PowerBI
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

So I just tested this with some dummy data and yes, the numeric field was presented in descending order.  I've never noticed this before.  With that said, I put the same field in a slicer and it displayed in ascending order, so I'm not sure why there is this discrepancy.

 

Not sure if there is a fix or workaround, but does it really matter?  The page level filter isn't really something the consumer of the report will see.