Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi everybody
I would like to create a bar chart with the expenditures on the Y-axis and the date on the X-axis. Based on the selected date in the slicer, e.g. 30.06.2023, the X-axis should display a time horizon of one year with the selected date in the slicer as the end date. In this example the start date would be 30.06.2022 with end date 30.06.2023.
The model consists of two tables "Expenditures" and "Slicer". The two tables have the following relationship with each other:
Expenditures[Due Date] : Slicer[Slicer Date] with one to one cardinality (1:1)
I have tried to create it with a column measure, but to no avail. The column measure looks like this:
Does anybody know how to implement a dynamic date X-axis based on a selected date in a slicer?
Thank you for your support.
Solved! Go to Solution.
Hi @mauchchr
This can be done by following steps:
1. Create a new table for dates and make sure this not have any relationship with you these two primary table
use measure in y-axis and due date in x-axis
and use date in filter that you have created in step 1
this hsould solve your probelm
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem
Hi @mauchchr
This can be done by following steps:
1. Create a new table for dates and make sure this not have any relationship with you these two primary table
use measure in y-axis and due date in x-axis
and use date in filter that you have created in step 1
this hsould solve your probelm
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem
Hi
Thank you for the suggested solution, it works very well.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
108 | |
108 | |
108 | |
90 | |
61 |
User | Count |
---|---|
171 | |
138 | |
132 | |
102 | |
86 |