Forum Discussion
Visual Interactions not working properly
Hi Anonymous,
You can try to apply the visual level filters in a measure. Then you can interact the visuals freely. Here is the file: https://1drv.ms/u/s!ArTqPk2pu-BkgQ1cYT_K_W_lUKBg
Measure KWH Sold = CALCULATE ( SUM ( 'Dashboard Data'[Value] ), 'Dashboard Data'[Attribute] = "KWH Sold" )Measure Boiler Capacity = CALCULATE ( SUM ( 'Dashboard Data'[Value] ), 'Dashboard Data'[Attribute] = "Boiler Capacity" )Best Regards!
Dale
Hello v-jiascu-msft,
Thank you for the reply, disabling the interaction between visuals with different attributes will stop showing blank results indeed, but they won't interact at all.
My intention with this post is as follows:
Is it possible for the interaction to filter by "Month" only, excluding the "Attribute" on the other line charts? Like I mentioned before, I wish the function of filtering by the slicer to be done by selecting a specific month from the column table, that means filtering all the other charts by "Month".
If you use the "Downtime" column chart as I intend, it will work and filter every other chart with filter interaction enabled by month. This chart, however, is generated from a different table with the column "Month" with a both-way, many-to-1 relationship.
here is the example:
Microsoft EmployeeHi Anonymous,
You can try to apply the visual level filters in a measure. Then you can interact the visuals freely. Here is the file: https://1drv.ms/u/s!ArTqPk2pu-BkgQ1cYT_K_W_lUKBg
Measure KWH Sold =
CALCULATE (
SUM ( 'Dashboard Data'[Value] ),
'Dashboard Data'[Attribute] = "KWH Sold"
)Measure Boiler Capacity =
CALCULATE (
SUM ( 'Dashboard Data'[Value] ),
'Dashboard Data'[Attribute] = "Boiler Capacity"
)
Best Regards!
Dale