The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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?)
No eventtime selected
Single event time clicked 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