Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I'm trying to set up a graph that shows the total amount of time spent on a project each month, including all time up to that point. My data is stored in a table with columns for the project number, date and time spent. I've set up a Single Selection Page Level Filter to filter the chart to show one project at a time.
My problem is that whenever I create a new meassure they aren't filtered by the current project. If I don't use a filter it takes the sum of all projects. I can hard code a filter for a specific project to get the right amount but I need to be able to filter dynamically by whatever project the line chart is filtered to.
Solved! Go to Solution.
I figured it out. The solution was just to add a slicer beside the chart instead of adding a page filter to the chart itself.
I figured it out. The solution was just to add a slicer beside the chart instead of adding a page filter to the chart itself.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |