Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
NoCode
Frequent Visitor

How to use a Slicer to hide table or entire table columns?

Hi everyone, 

I'm trying to make table visual that is able to show monthly health information for several services. The underlying excel sheets will contain two months of data. I want to find a way to display only the selected month's (current or previous) information columns. I'd like to either use a slicer to either enable/disable the relevant columns or use two tables, with one being hidden by the use of a slicer. The slicer will be labeled "Previous Month" and "Current Month".

I would like the table views to look like this.

|Service | Health Col 1 (Current Month)| Health Col 2 (Current Month)| | Health Col 3 (Current Month)| 
|Burgers| Good                                      | Bad                                           | Great                                              |
|Fries     | Good                                      | Bad                                           | Great                                              |


|Service | Health Col 1 (Previous Month)| Health Col 2 (Previous Month)| | Health Column 3 (Previous Month)| 
|Burgers| Good                                        | Bad                                            | Great                                              |
|Fries     | Good                                        | Bad                                            | Great                                              |


What would be the best way of achieving this? Thank you!

1 ACCEPTED SOLUTION

@NoCode try this video using buttons instead of slicer



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

6 REPLIES 6
parry2k
Super User
Super User

@NoCode this blog post will get you going. 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Hi Parry,

Thank you for the response. I gave it a try, but my version of Power BI doesn't have an ellipses next to the word Color under Background. Is there any other workaround to do what I need?

@NoCode any reason you cannot upgrade your version to most recent one (July 2019)? 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

That update is not supported by my business at the moment.

@NoCode try this video using buttons instead of slicer



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Thanks parry2k. Worked perfectly. You're the man!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.