Forum Discussion
How to 'Hide' an Error Message Behind a Card
Hi CMoppet,
One option would be to cover the table with a shape with conditional fill, but this would not allow for the correct use of the table.
So I believe the best way is for you to create a measure were if countrows>limit (don't know hor much data it is), then filter all rows, else, just return a normal column. Set this measure in the filter panel.With an empty table, you can just hide the column headers with the shape as mentioned before.
Here I did a small version of how you can have the table have no values if more than 20 rows are available.-----
Here is the dax formula I used:
FilteredRows =IF(CALCULATE(COUNTROWS(Winners),ALLSELECTED(Winners)) <= 20,1,BLANK())Remember to apply it in the filter panel and select "apply slicer". Also, take into account its not counting the amount of different values, but the amount of rows the table visual has.Hope this helps, it's certainly a quite interesting scenario!
Hi CMoppet,
One option would be to cover the table with a shape with conditional fill, but this would not allow for the correct use of the table.
So I believe the best way is for you to create a measure were if countrows>limit (don't know hor much data it is), then filter all rows, else, just return a normal column. Set this measure in the filter panel.
With an empty table, you can just hide the column headers with the shape as mentioned before.
Here I did a small version of how you can have the table have no values if more than 20 rows are available.
-----
Here is the dax formula I used:
- Thank you for your help 🙂 Very much appreciated
