Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
New to PowerBI. Thanks in advance.
I am wokring on a report with powerbi to display the projects that's going on in each financial Year. I have a dataset like this:
and I try to create a dashboard like this,
I hope I can use the year slicer to filter the projects that are going on,
For example, if I choose year 2026, project 1 should be included as well, because it covers.
and I need the other charts to be interactive as well.
Just wondering is there an easy way for this.
Thank you.
@ericnz , You can try like Current Employee Approch of HR
or
Hi Thank you so much for the quick response. That's really helpful.
Just two more questions that might seem bit silly:
1. so I would need to create a measure for each visual so that I can use one slicer to filter other visuals as well?
2. For the matrix in the report, there aren't any calculations, just a display of the rows in original dataset. How to write the code for this?
Thank you.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |