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.
Hi,
Is it possible to make a field as a filtered sub heading?
I'm not sure what is the proper term but for example:
Department | Project |
Department 1 | |
People 1 | |
People 2 | |
People 3 | |
Department 2 | |
People 4 | |
Department 3 | |
People 5 | |
People 6 |
People 1-3 has Department 1, People 4 has Department 2 and People 5-6 has Deparment 3.
As you can see they are filtered/group by Department which is a sub heading for the ones below it (It also works even if the first one is on the same row as department)
Solved! Go to Solution.
The Matrix Visual should do this for you automatically (make sure to expand it to include the additonal columns which are by default hidden. (double down arrow). If you want a separate columns be sure to turn off Stepped Layout under Row Header section of formatting pane.
The Matrix Visual should do this for you automatically (make sure to expand it to include the additonal columns which are by default hidden. (double down arrow). If you want a separate columns be sure to turn off Stepped Layout under Row Header section of formatting pane.
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 | |
99 | |
82 | |
70 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |