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.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi BA_Pete , 

 

I got your point but I can't use relative date slicer as it hampers my UI, I don't have to change my UI, Have some UI Constraints as well.
Need to do something by measure or creating column.

Thanks ! 

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
6 years ago

No problem.

Just add the monthName column, use this as the chart axis, and then use the visual-level filter to do the Top N solution I mentioned.

 

Pete