Forum Discussion
Inquiry about Slicer Function In PBI Desktop
Can I disable certain graph to have slicer effect? I am using September/October version?
Yes, but you need to deny the filtering from Slicer. Just go to "Format"->"Edit Interaction"。
Is it possible to have 2 slicers in a single Power bI sheet?
Yes, you can keep multiple slicers within single report page.
Can I fit the colour in the graph? For instance, red colour will display for the bar that need special attention while I select different year in the slicer?
Yes, you can assign a color for specific Legend item.
Can I delete column (year) in the slicer that contain no data in the for the whole year? If not, any suggestion to remove the data selection when put month in the slicer? The filter function for the slicer is not available.
No, it's not possible. Slicer will populate all values in your data field. It can't determine if an item has corresponding fact data or not.
Regards,
Can I disable certain graph to have slicer effect? I am using September/October version?
Yes, but you need to deny the filtering from Slicer. Just go to "Format"->"Edit Interaction"。
Is it possible to have 2 slicers in a single Power bI sheet?
Yes, you can keep multiple slicers within single report page.
Can I fit the colour in the graph? For instance, red colour will display for the bar that need special attention while I select different year in the slicer?
Yes, you can assign a color for specific Legend item.
Can I delete column (year) in the slicer that contain no data in the for the whole year? If not, any suggestion to remove the data selection when put month in the slicer? The filter function for the slicer is not available.
No, it's not possible. Slicer will populate all values in your data field. It can't determine if an item has corresponding fact data or not.
Regards,