Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Arkhos94
Helper IV
Helper IV

Table - show warning message if too many row

I have a report that show if my commercial team performed their sales correctly

On the bottom half of the report page, there is a table showing the list of the sales that has not been performed correctly

 

The report is made to be exported in PDF through power automate (then emailed) so If there is too many line of the table I want it to show a message on the table like "Above 25 sales performed incorrectly, please go to the power BI report to check the list".

 

Any idea on how I can make it so, if the number of "incorrect sales" is above 25 (I already have a measure that count incorrect sales), the content of the table is replaced by a message ?

1 ACCEPTED SOLUTION
Adescrit
Impactful Individual
Impactful Individual

Hi @Arkhos94 ,

This might work but it's a tricky one.

1. Your measure to count the number of rows should be something like this:
         

CountRows = IF( COUNTROWS( 'Table' ) > 3, "Too Many Rows", "" )
 
2. Add a card visual and lay it over the top of the table. Ensure the background is 100% transparent. Add your CountRows measures.
3. Set up conditional formatting on the card as follows:
 
Adescrit_0-1701162415522.png

 

Adescrit_1-1701162442233.png

 

This won't necessarily replace the table but add a message overlayed on top of it.


Did I answer your question? Mark my post as a solution!
My LinkedIn

View solution in original post

1 REPLY 1
Adescrit
Impactful Individual
Impactful Individual

Hi @Arkhos94 ,

This might work but it's a tricky one.

1. Your measure to count the number of rows should be something like this:
         

CountRows = IF( COUNTROWS( 'Table' ) > 3, "Too Many Rows", "" )
 
2. Add a card visual and lay it over the top of the table. Ensure the background is 100% transparent. Add your CountRows measures.
3. Set up conditional formatting on the card as follows:
 
Adescrit_0-1701162415522.png

 

Adescrit_1-1701162442233.png

 

This won't necessarily replace the table but add a message overlayed on top of it.


Did I answer your question? Mark my post as a solution!
My LinkedIn

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors