- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dynamic Date Axis
I have seen lots of tutorials on adjust charts based on slicers, but I'd like to use one chart page for several projects and have the x-axis change the start and end date accordingly when someone selects a project. I don't feel the end user should have to go select the appropriate date range.
I am connected to a PWA report server, so I have a project table and task table and have a query that is filtered down to the tasks I have graphed in a burn-down chart. I have created a date table that shows the w/e Friday dates for all weeks between the first basline finish date and the last baseline finish date. Unfortunately these vary widely between projects and I can't get the chart to change the dates on the axis based on the project I've selected. Has anyone seen a tutorial on this? I've even got a table that grouped all the projects to show the first w/e date and last w/e date for each project, but can't figure out how to use that as a filter against the date table I created.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You may add an appropriate measure to Visual level filters.
https://community.powerbi.com/t5/Desktop/Create-Axis-values-as-slicer/m-p/587458#M278489
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You may add an appropriate measure to Visual level filters.
https://community.powerbi.com/t5/Desktop/Create-Axis-values-as-slicer/m-p/587458#M278489
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That might be the solution, but I sure couldn't make it work. I tried a few different methods and can't get the dates to filter based on the project selected. I have a table that shows the project name and the minimum and maximum dates that should be on the chart (CRMinMaxFinDates) and created this measure, but that's a list and won't work as a filter, so I did the same thing, making it a dynamic table and tried to use the column from that table as the X-Axis, but it doesn't filter when I select the project.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I got it to work by replacing the MIN and MAX in the IF statement with SELECTEDVALUE. I thought when I'd done that initially it didn't work, but it does seem to. Thanks for your help.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
09-22-2024 10:17 PM | |||
08-26-2024 09:18 AM | |||
12-10-2018 05:55 PM | |||
09-11-2024 11:06 AM | |||
09-13-2024 01:56 PM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
47 |