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.
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 👍
Proud to be a Super User! |  |
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
