Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two tables namely App and Job. I am creating a graph that shows whether the job was finished/unfinished.
I would like to display the x-axis such that it shows the last fifteen days. I can't use the filter functionality of power bi since I would have to change the current date everyday. How can I make it to where it updates itself ? Any ideas?
Update: Here's what I have done so far but it's still not giving me what I want. I have created a calculated column:
LastFifteen = TODAY() - date. Doing this diaplays only the dates that the in the table. For instance, I do not have a record on 24th of Feb, but I would still like to display 24th of Feb on my x-axis because it falls in the last 15 days range. How can I do that?
Solved! Go to Solution.
I created a custom table with the help of calender function, then I created relation with date column from custom table to original table date column.
May be you can create a custom table like below and make relation with date column.
mydatetable = CALENDAR(TODAY()-15,TODAY())
I would appreciate if you can provide an example. I am still confused. Please see my updated post.
Hi @sieed,
Have your tried the solution provided by rocky09? I just verified that it should work in your scenario.
1. Use the formula below to create an individual Calendar table.
Calendar = CALENDAR(TODAY()-15,TODAY())
2. Create a relationship between your Job table and the created Calendar table with the date column.
3. Use the date column from Calendar table as the Axis for the Chart on report.
Regards
I created a custom table with the help of calender function, then I created relation with date column from custom table to original table date column.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |