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 August 31st. Request your voucher.
Hi, I've the following issue with visualisations, would appreciate any help.
Currently my charts - Factor and SubFactor are shown with a measure Ignore_Agg_Val as values.
Default:
When I click on Factor on the left chart, it correctly filters the subfactors belonging to the factor on the right:
However when I select the subfactor on the right, it resets the chart on the left AND right:
Is there any way I can stop this from happening? Pressing "None" as interaction between the visuals (from SubFactor to Factor) did not seem to work
Solved! Go to Solution.
Hey @Wendeley-North ,
what exactly should be your desired behavior?
In general the crossfilter/crosshighlight feature supports only one interaction. That means you select something from the first visuals and the rest filters or highlights. If you then select something else from another visual, the first interaction is reset and the interaction from the second visual happens.
You cannot override that behavior. You could either use a slicer to keep the selection of the first visual or use a drillthrough to keep the filter and then use another interaction.
Sorry about that.
Hi,
You can hold down CTRL as you click. This will apply crosshighlighting and maintain your clicked visual items. Not ideal as users need to be told to hold the CTRL key but its the only way I have found to get this functionality.
It would be amazing if there were an option to make the visual filter work like a slicer.
Hey @Wendeley-North ,
what exactly should be your desired behavior?
In general the crossfilter/crosshighlight feature supports only one interaction. That means you select something from the first visuals and the rest filters or highlights. If you then select something else from another visual, the first interaction is reset and the interaction from the second visual happens.
You cannot override that behavior. You could either use a slicer to keep the selection of the first visual or use a drillthrough to keep the filter and then use another interaction.
Sorry about that.
That does makes sense, thanks.