![]() ![]() Using Calculated tables Calculated tables can be used to generate filtered views of other tables in the model.However some of you might prefer built-in visuals, because some of custom visuals are not designed for mobile friendly reports. because with clicking on another visual the selection on slicer remains but not the selection of an item in another visual. However this won’t be exactly same feature as slicer. ![]() such as stacked column chart or bar chart. Using some specific visuals as slicer can be the other option.but then other elements in the report will be filtered based on predefined items. One can be defining the filter in the page level or report level.There are number of workarounds for this challenge The work around in this post might get dated very soon because I expect Power BI team to fix this soon, however in the meantime this workaround will help some people I believe. However the demand for this feature is already high! you can see the idea published here in Power BI user voice, so feel free to vote for such feature □ Unfortunately this feature isn’t supported at the time of writing this post for Slicers. With all other visual types (Such as Bar chart, Column chart, line chart….) you can simply define a visual level filter on the chart itself. Or you might want to pick few items to show in the slicer. a slicer for customer name when you have 10,000 customers isn’t meaningful! You might be only interested in top 20 customers. You might have too many items to show in a slicer. The idea of this blog post came from a question that one of students in my Power BI course asked to me, and I’ve found this as a high demand in internet as well. If you want to learn more about Power BI, read Power BI online book from Rookie to Rock Star. ![]() However in the meantime here is a work around for filtering slicers using calculated tables. Unfortunately current version of Power BI Desktop doesn’t support visual level filter on slicer, and I’m sure this feature will come soon. So this is normal that we want to filter the items in the slicer itself. You can filter all visuals in Power BI except Slicer! In fact slicer itself is a type of filter, however there are some times that number of items in slicer is too many. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |