Allowing a table to only show data after a slicer has made a selection..

[Ryan_Pazos]

Problem:

I wish to have a table display information only when a slicer is used, and not show anything if no selections are made via the slicer.

Example:

There is 1 slicer visual for "Company", 1 table visual for "Orders", and 1 table visual for "Order Contents"

• If a selection is made on the slicer("Company"); the tables("Order" & "Order Contents") display the correct information (regarding the company- orders placed- & order contents)
• If NO selections are made with the slicer("Company") -- the tables("Orders" and "Order Contents") display ALL "Orders" & "Order Contents" in the system.

I would like to understand how to hide the data in the tables until a slicer selection is made.

If a Measure is needed to be created - how can i make sure the Measure plays nice;

Which tables do the ISFILTERED/HASONEVALUE/LASTNONBLANK commands point to

Slicer= organization (Lines table)

Table1= salesordernumber (Header table) [want to hide data within until slicer makes its selection]

Table2= linedescription (Custtable) [want to hide data within until slicer makes its selection]

(The relationship between these tables/visualizations are present and functional)

Thanks in advance, PowerBI Experts!

[v-yuta-msft]

Hi Ryan_Pazos,

I'm afraid slicer visual doesn't support this feature in current. You can submit your idea here: https://ideas.powerbi.com.

Regards,

Jimmy Tao

[Ryan_Pazos]

Thanks for the reply Jimmy,

if that is the case -- are you aware of any visuals/combinations that can be used to achieve the desired results?

Regards,

RP