Need Support with Customizing Table visual.

[Raj2410]

Hi Need some help.

These are my Slicers and I have made sure that my slicer don't interface or intract with my visual.

This is my visual -1 created for the year 2023.

The data for April to Dec exist in my table but as we are in Month of MArch  I want to present only data from Jan -March.

I do want to keep the April to Dec headers but I want them to stay blank. Then in April I want the data for April to start showing.

Also at the end of table in YTD I want the table to calculate only Jan Feb and March only for now and when we get to April.

I want the YTD to change to calculating Jan to April.

This below visual is something I want to achieve.

Please suggest.

[Raj2410 · Accepted solution]

I THHINK THIS IS WHAT I WANT TO DO - HIDE VALUES UNDERS SPECIFIC COLOUMNS IN MATRIX TABLE VISUAL BUT KEEP COLOUMN HEADER.

[Anand24 · Accepted solution]

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

[Anand24 · Accepted solution]

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

[Raj2410]

@amitchandak  @Greg_Deckler  Can you suggest.

[Greg_Deckler · Accepted solution]

@Raj2410 I think something like putting an IF at the end of your measure like IF(MAX('Date'[Date]) > TODAY(), BLANK(), [Measure])

[Raj2410 · Accepted solution]

I THHINK THIS IS WHAT I WANT TO DO - HIDE VALUES UNDERS SPECIFIC COLOUMNS IN MATRIX TABLE VISUAL BUT KEEP COLOUMN HEADER.