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 a report page with a matrix containing header information about some devices and a line chart containing the time series temp/pressure data of the same devices. I notice that when a device row in the matrix is clicked, it correctly filters the line chart to the approprate device. However, when I click anywhere on the line chart, it resets the matrix.
Is this documented behavior?
In the images below. (1) is the default. (2) is when I select any device on the matrix. However, in this situation, when I click on the line chart, everything resets back to (1).
Images attached and also a link to a sample PBIX file. Please let me know if you need any more information.
When you click on a line you are filtering for the device, if you click in the chart you are filtering on an eventtime. When you click in the line graph your table will actually change. I added a visual to show what eventtime is filtering the table (where did I click in the chart?)
If you want to use both as a filter you can click on a row in the table then hold CTRL and click on a spot in the chart. That will select both the device id and eventtime.
@jdbuchanan71I also used the edit interaction to eliminate the matrix from the line chart's interaction, but that did not help. Is this also intented behavior?
I am tempted to try the below for now, as for some reason the behavior irks the user quite a bit:
https://community.powerbi.com/t5/Desktop/Make-a-Table-ReadOnly/td-p/765716
yes, this is a default behaviour, when you click on a chart element to cross filter other charts, the filter is applied. As soon as you click on the same chart or any other chart, this click clears selection and removes the filter. In order to make the filter sticky, you should create a slicer. that will keep the filter on when selected regardless of what the users is clicking on the screen
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |