Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

How to use date-based measures as axes in a chart to work with other filters.


Please support the files linked below.



The date specified in the slicer is used to control the table on the left.

We have created a measure that numbers every 7 days from the start date.

I want to use this "wk_no" as the X axis of the chart and Sales on the Y axis to create a sales graph.pict3.png

How can I make "wk_no" a column and use it for the X axis of the chart, so that it works together when the date of the slicer is adjusted?

Frequent Visitor

Is there any other way to achieve this?

Power BI, too hard. (T_T)

Super User
Super User

@hide , You should create this as column in Date table




To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Thank you very much!

I'm sorry, the following is difficult and I can't keep up with the understanding.

Can it be achieved without "Power query"?

Is it possible to use the value allocated every 7 days as a dimension?

(Isn't it possible to change dynamically with DAX?) )

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.