Blank Visual Until Slicer Selected

Used for anything related to the new Power BI Desktop and Service tools
mpfarhat
Posts: 1
Joined: Fri Mar 29, 2019 6:05 am

Blank Visual Until Slicer Selected

Postby mpfarhat » Fri Mar 29, 2019 11:33 am

Sincere thanks in advance for any help anyone can offer with the following.

None of the proposed solutions I've seen for this type of issue is working in my scenario.

This sample file https://1drv.ms/u/s!AgNZxIL7LLJEpSzJX4w5R2v2vQ6V contains two pages: "This Works", and "This Does Not Work" and each page contains one Slicer, and one Table.

The first page works exactly as expected:
- Uses two tables in the model which have a One-to-Many relationship
- The Table visual is blank until at least one value is selected in the Slicer
- The Table visual displays the correct rows depending on the values selected in the Slicer

The second page is not working as expected:
- Uses three tables in the model, one of which is a bridge table
- The Table visual is blank until at least one value is selected in the Slicer
- However, the Table visual displays all the rows regardless of the values selected in the Slicer

After many hours of research and trial/error I'm still stumped.

Again, thanks for any help!

PWilliams
Posts: 3
Joined: Thu May 16, 2019 10:16 am

Re: Blank Visual Until Slicer Selected

Postby PWilliams » Thu May 16, 2019 11:16 am

Hello

'The Table visual is blank until at least one value is selected in the Slicer'

Could you please let me know how you did that? I am trying to do that but so far I have come up short. I'd really appreciated it.

Regards,
Paul.


Return to “Power BI Desktop/Service”

Who is online

Users browsing this forum: No registered users and 0 guests