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.
Helper IIIThank you for responding...yes
I don't know how to paste a screen shot in so I'll type how it looks. They are checkboxes :
M_Value(All) (field)
Filter Type
Basic filtering
12
11
10
9
8
7
If you can tell me how to paste a snip copy in this, I can do that
Cat
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...
- dkay84_PowerBI
And 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.
- Cathryn
I'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