Forum Discussion

Raj2410's avatar
Raj2410
Helper I
3 years ago
Solved

Need Support with Customizing Table visual.

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 Apri...
  • Raj2410's avatar
    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.

     

  • Anand24's avatar
    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

  • Greg_Deckler's avatar
    Greg_Deckler
    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])