Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

monthwise previous year data on line chart

Hi everyone,  Hope you guys are doing great. I am new to POWER BI, I want to implement one thing that if i have admissions data that contains admission ID and a DATE Column that contains date in t...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    You could create a measure and add it in the filter pane.

    Measure = 
var a = DATEDIFF(SELECTEDVALUE('Table'[Date]),TODAY(),MONTH)
return
IF(a<=12,1,0)

    Then set the rule to show the result whose measure is 1.

     

v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

You could create a measure and add it in the filter pane.

Measure = 
var a = DATEDIFF(SELECTEDVALUE('Table'[Date]),TODAY(),MONTH)
return
IF(a<=12,1,0)

Then set the rule to show the result whose measure is 1.