Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

conditional formatting with multiple columns in a histogram

Hello,   I would like to do a conditional formatting on multiple columns of my histogram as follow : Have all columns after february in grey.   It seems I can't manage it in a histogram with mor...
Need Help
v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous,

 

What your expected output? If you want to have all values after February showed blank values.

You can try measure as:

If(
   Month(Date[Date])>2,
   blank(),
   [Test]
)

 

Best Regards,

Link

Anonymous's avatar
Anonymous
Not applicable
5 years ago

It does not work as I can't add a date to It measure.

 

However I tried the following measure :

if(month(DistinctDate[Date].[Date])>2,BLANK(),calculate(totalYTD(sum(UploadFile_CRM_13012020[Montant 2021]),DistinctDate[Date].[Date]),UploadFile_CRM_13012020[Statut]="Clôturée (gagnée)"))
 
But It does not show the YTD cumulated until february. All values from february to end of year are blank.
 
Any advice ?
  • v-xulin-mstf's avatar
    v-xulin-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous

     

    Could you provide sample data? The measure doesn't seem to be a problem.

     

    Best Regards,

    Link