cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tas1
Advocate I
Advocate I

powerbi desktop table showing only one value

Hi All,

 

I'm newto Powerbi I have a problem where I have this table:

 

Channels               Type

Channel1               Live TV

Channel2               VOD

Channel3               VOD

Channel4               VOD

Channel5               Live TV

Channel6               Live TV

Channel7               Live TV

 

I'm using the second column as slicer but when I use it any where in the visuals area it's showing only "Live" , I tried using it as a page filter the same happens again I find only "Live" in teh tick list..

 

PS: the columns I'm trying to filter by this column are from related table ,,Ihope this peice of information helps!

 

Heeeeelp Please !!!!

 

 

1 ACCEPTED SOLUTION
v-huizhn-msft
Microsoft
Microsoft

Hi @Tas1,

The slicer is used to filter rows in table. We are unable to use it as page filter.

>>I tried using it as a page filter the same happens again I find only "Live" in teh tick list..

When you click "Live TV", it only return corresponding context for Live TV, right? If it is, you can use a page level filter, please review the following screenshot.

1.PNG

Please see more details for different filter in this document.

Best Regards,
Angelia

View solution in original post

2 REPLIES 2
v-huizhn-msft
Microsoft
Microsoft

Hi @Tas1,

The slicer is used to filter rows in table. We are unable to use it as page filter.

>>I tried using it as a page filter the same happens again I find only "Live" in teh tick list..

When you click "Live TV", it only return corresponding context for Live TV, right? If it is, you can use a page level filter, please review the following screenshot.

1.PNG

Please see more details for different filter in this document.

Best Regards,
Angelia

Hi @v-huizhn-msft 

 

Thank you so much for your feedback thats really helpful!!! it worked just the way you say.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.