Forum Discussion

hamburgernic's avatar
hamburgernic
New Member
1 year ago
Solved

using a measure as a y axis

Hi,   I am looking to use a measure (number of months) as a y axis but am unable to do so   context example: I have a few book loan records that are already due to be returned. I want to track o...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    hI hamburgernic 

    If you're going to compare the due date with the current date, a simple DATEDIFF calculated column against today's date should be enough

    Months Due = 
DATEDIFF ( 'Table'[Due Date], TODAY(), MONTH )

    However, if you want to determine how many months a book loan is due based on a date selected in a slicer — and expect the numbers in the visual to change accordingly — this approach will not work. Calculated columns are not responsive to slicer selections and will not adjust their values dynamically. That said, based on your description, the calculated column provided above should still meet your needs.

v-karpurapud's avatar
v-karpurapud
Icon for Community Support rankCommunity Support
1 year ago

Hi hamburgernic 

Could you please confirm if your query have been resolved the solution provided by danextian and DataNinja777 ? If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.

Thank you