Forum Discussion
Need Support with Customizing Table visual.
- 3 years ago
I THHINK THIS IS WHAT I WANT TO DO - HIDE VALUES UNDERS SPECIFIC COLOUMNS IN MATRIX TABLE VISUAL BUT KEEP COLOUMN HEADER.
- 3 years ago
Hi Raj2410 ,
For hiding data from April to December, you can use conditional formatting on font-color such that if month > month(today()), then font-color = white. This will enable overlay of white font with white background and hence the data would be present in the table but it will not be visible to the users.
As for the 2nd query of showing only data till March only for totals, that is something that might not be possible in Power BI at present on a default.
As a work-around, you can create a month named "Total" and show it on the table. Make sure from backend itself that this "Total" has sum of Jan to March in it.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedIn - 3 years ago
Raj2410 I think something like putting an IF at the end of your measure like IF(MAX('Date'[Date]) > TODAY(), BLANK(), [Measure])
amitchandak Greg_Deckler Can you suggest.
Raj2410 I think something like putting an IF at the end of your measure like IF(MAX('Date'[Date]) > TODAY(), BLANK(), [Measure])