Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
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?
Is there any other way to achieve this?
Power BI, too hard. (T_T)
@hide , You should create this as column in Date table
examples
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...
https://medium.com/chandakamit/cheat-sheet-any-weekdays-week-start-date-just-one-variable-apart-6b2e...
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?) )
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
88 | |
73 | |
64 | |
60 |