Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

‎08-05-2019 02:15 PM

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!

Labels:
Message 1 of 7
1,070 Views
0
1 ACCEPTED SOLUTION
parry2k
Super User
Super User
In response to Anonymous

‎08-06-2019 08:30 AM

@Anonymous 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

Message 6 of 7
1,048 Views
0
6 REPLIES 6
parry2k
Super User
Super User

‎08-05-2019 02:21 PM

@Anonymous 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.

Message 2 of 7
1,065 Views
0
Anonymous
Not applicable
In response to parry2k

‎08-06-2019 08:19 AM

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?

Message 3 of 7
1,055 Views
0
parry2k
Super User
Super User
In response to Anonymous

‎08-06-2019 08:26 AM

@Anonymous 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.

Message 4 of 7
1,052 Views
0
Anonymous
Not applicable
In response to parry2k

‎08-06-2019 08:27 AM

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

Message 5 of 7
1,050 Views
0
parry2k
Super User
Super User
In response to Anonymous

‎08-06-2019 08:30 AM

@Anonymous 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.

Message 6 of 7
1,049 Views
0
Anonymous
Not applicable
In response to parry2k

‎08-06-2019 10:20 AM

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

Message 7 of 7
1,042 Views
0

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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

View All