Restricting all visuals to display no less than X number of data rows.

[LPlenty]

Hi,

I need to ensure that all visuals within my report can not be sliced to less than 3 rows of data. Therefore whatever you click to interact with other visuals, no visuals will ever display anything when it contains less than 3 rows of data. 

Is there DAX or something else that can be used to achieve this? I want all visuals to be able to interact with each other as they all have elements that have over 3 rows of data, but equally also have those below. 

Thanks in advance.

[Anonymous]

Hi, @LPlenty 

Based on the way from miTutorials, perhaps you could just count the number of rows, with the filter pane set to is greater than or equal to 3.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[LPlenty]

Hi Yang, I have tried this and filter on page by unique idetifier equal to or greater than 3, but it's not doing what I need it to unfortunately. 

[Anonymous]

Hi, @LPlenty 

You can share your desired implementation and a pbix file free of sensitive data for testing (use tools like Google Drive, One Drive, etc. to share the link containing the pbix file)

Here are some notes:
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Best Regards,
Yang
Community Support Team

[miTutorials]

You can create a measure that checks the number of rows in a table after filtering and return BLANK() if the count is less than 3.

• Select each visual.
• Drag the ShowVisual measure into the Filters pane under Visual level filters.
• Set the filter condition to "is not blank".

ShowVisual = IF( COUNTROWS( VALUES( 'YourTable'[YourColumn] ) ) < 3, BLANK(), 1 )

[LPlenty]

Hi miTutorials,

I have added the measure in and into the visual level filters and set to is not blank as described, but unfortunately its still enabling the slicing of one visual to another. See below, i have selected 1 within the bottom visual and it's sliced the top visual still. Any ideas?

[miTutorials]

Can you share a pbix file with dummy data to review ?