Forum Discussion
Helper IVTable - 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 ?
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:This won't necessarily replace the table but add a message overlayed on top of it.
1 Reply
- Adescrit
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:This won't necessarily replace the table but add a message overlayed on top of it.