Measure as X axis

[Anonymous]

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.

[Idrissshatila]

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