Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Measure as X axis

Hi all,

 

I am creating a AR aging histrory report. I want to make a chart like Chart 2, which is aging time by open amount. 

The age will be definded as age= selected date - due date as Charte 1 showing. The peroblem is I can't put measure "age" into X axis, because selected date is a dynamic value. How can I address this issue? Please help me out.

 

Thank you in advance!

Bei

 

 

Chart 1.

Chart 2.

 

 

1 Reply

  • Hello Anonymous ,

     

    so what you can do is create a calculated column to specify the ranges then use it as x-axis, otherwise you can't use a measure as x-axis.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    Follow me on Linkedin