Forum Discussion

venriquez's avatar
venriquez
Regular Visitor
3 years ago

How to hide a column in tables when using a slicer

I have a Power BI report with 2 tables with total columns. When I use the slicer for the page it changes the everything correctly but the tables show the totals for slicer choice as well as the totals columns with the same number. I would like to either hide the total columns completely when the slicer is in use but keep it visual when the slicer isn't or keep the total as the overall total and then show the slicer choice total next to it. Below is what the report looks like with no options picked on the slicer. Notice the Total column and the MWSE column in the 2 tables. 

Now that I have picked something off the slicer notice the total and MWSE columns next to the chosen item

Is there a way to hide the total column and the MWSE column when the slicer is in use? Or is there a way to have it show the total from the top visual next to the option total? 

 

 

Need Help

1 Reply

  • JirkaZ's avatar
    JirkaZ
    Icon for Solution Specialist rankSolution Specialist
    3 years ago

    Just a recommendation - keep the visuals consistent. Don't remove columns conditionally. 

    There are some techniques involving bookmarks that you could use. 

    You could also define the measure used in those tables to show zeros for non-selected slicer values etc. 

    It really depends on your proficiency in DAX  and Power BI overall. 

    But my recommendation stands - keep it consistent. Those columns don't do any harm in the end.