Forum Discussion
Helper IIIfilters
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.
Microsoft EmployeeYou have to use the Snip tool (or equivalent) and save the image to your machine, then attach it to your post as a photo. Painful I know...
Microsoft EmployeeAnd please indicate what the data type is for the field in question.
- dkay84_PowerBI
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.
CathrynI'm new to using Power BI so I'm sorry if this is a naive question but the filter is visible to the customer so they can filter on what month they want to see. Should that be a slicer instead? What's the difference? Our customers can see the filters
- dkay84_PowerBI
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.