Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hey guys,
I'm trying to create a line chart that shows the data for the past few months based on the date I choose via slicer. Anyone know how I could achieve this? Thanks.
Solved! Go to Solution.
@Anonymous,
You may take a look at the following post.
@Anonymous,
You may take a look at the following post.
@Anonymous are you trying something like this..
http://community.powerbi.com/t5/Desktop/Dynamic-date-x-axis/m-p/448578/highlight/false#M207597
No what I meant was that I want the user to be able to select a certain week or month, and then the visual show data for that ranging from the selected month/week back to however many months back I select. i.e They select december (assume a year selection is made form another slicer) and see data from October-December. If they select June they see data from April-June.
@Anonymous
@Anonymous,
You need to create independent table as below
Create a measure:
User | Count |
---|---|
84 | |
71 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |