Display visuals a blank until there is a selection in the slicer

[Marico]

Hi,

I have a requirement from the client where the ask is to show the visuals as blank until any value is seached from the slicer.

So, when at first report is open all the visuals should show no data and display the values only for the searched values in the slicer. Is this possible?

[v-pgoloju]

Hi @Marico,

Just following up to see if the response provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

Best regards,

Prasanna Kumar

[Marico]

No, I haven't got the solution yet.

[v-pgoloju]

Hi @Marico,

Just following up to see if the solutions provided by community members were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[v-pgoloju]

Hi @Marico,

You're on the right path with your filtered1 measure it works for multi-row cards because those use measures. But in table visuals, you’re using columns directly, and DAX can’t hide them the same way. That’s why the table still shows data even when no slicer is selected.

try below measure
IF ( [filtered1] = 1, SELECTEDVALUE('Product'[Product Name]), BLANK() )

then Use filtered1 as a visual level filter on the table, and set it to only show when the value is 1.

If the issue still persists, we kindly request you to share the sample data in a workable format such as text, an Excel file, or a PBIX file with sample data instead of screenshots.  This will enable us to assist you more effectively.

Thanks & regards,

Prasanna Kumar

[Marico]

@v-pgoloju Sorry, I didn't understand this. The SELECTEDVALUE condition should inlude all the columns of the filters applied on the page or all the columns used in the table visual or only one column used in the table?

[v-pgoloju · Accepted solution]

Hi @Marico,

the SELECTEDVALUE condition doesn’t need to include all the columns used in the visual, but it should reference the columns from slicers or filters that control when you want data to appear.

For example, if your visuals are controlled by slicers like Product ID, Product Type, or Tracking Status, then your logic should check those columns not necessarily every column shown in the table.

Regards,

Prasanna Kumar

[v-pgoloju]

Hi @Marico,

Just following up to see if the response provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

Best regards,

Prasanna Kumar

[v-pgoloju]

Hi @Marico,

Thank you for reaching out to the Microsoft Fabric Forum Community.

To ensure that all visuals in your Power BI report remain blank until a slicer selection is made, you can create a DAX measure that checks if a slicer value has been selected. This measure returns a blank result when no selection is made, effectively hiding the data. You can then wrap your original measures or descriptive fields within this logic so they only display once a slicer (such as Device ID or Date) is used. For table visuals that directly use columns, you can apply this measure as a visual-level filter to control visibility. Modify the Response from  @danextian  will help in achieving your requirement.

Best regards,
Prasanna Kumar

[Marico]

Hi @v-pgoloju, @danextian and @Idrissshatila,

I tried your suggestions and created the following measure in my sample data.

filtered1 =

IF (

    ISFILTERED('Product'[Product ID]) || ISFILTERED('Product'[Product Type]) || ISFILTERED('Product'[Tracking Status]),

    1,

    0

)

This measure is applied as a visual level filter to each multi-row card (without summarization) and table but it only goes blank for multi-row card. 

[danextian]

Hi @Marico 

You can compare a measure's total value with and without filters applied, and return blank if they are the same.

Sales Amount - Return Blank = 
VAR _NoFilter =
    CALCULATE ( [Sales Amt], REMOVEFILTERS () )
VAR _WithFilter =
    CALCULATE ( [Sales Amt], ALLSELECTED () )
RETURN
    IF ( _WithFilter <> _NoFilter, [Sales Amt] )

Note: Persistent filters will override this behaviour.

[Marico]

Hi @danextian,

In actual data, I mostly have description columns in the table and card visuals. Sharing the report layout with you. Can you please let me know how to show values as blank until there is a selection in the slicer based on below layout accross screen?

[Idrissshatila]

Hello @Marico ,

check this out, this will solve your case
Nothing selected in Power BI Slicer? Then don't show data!
https://youtu.be/sXn-QZqLD-8?si=p8AQZXOTIe8LQ6kM

[Marico]

Thanks for sharing this @Idrissshatila. I went through the solution, however, my actual report layout has multiple filters, so for every filter, do we need to create that 1 and 0 flag?

and on every visual on the report, do we need to place need to place all the filter flags created above?

Below is how my report layout looks like