powerbi desktop table showing only one value

[Tas1]

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 !!!!

[v-huizhn-msft · Accepted solution]

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.



Please see more details for different filter in this document.

Best Regards,
Angelia

[Tas1]

Hi @v-huizhn-msft 

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