Forum Discussion
Need help!!!!!
I have this measure as below.
I am using this major in matrix visual with other column, problem i am facing is this measure is causing bypasing of the selection in slicer, there is no error or issue in the red, amber and green count measure as i return either of them instead of svg measure repspects the selection in slicers.
I tried making a calculated column but that is not giving me required image, even tho it resolved the bypassing issue.
2 Replies
- AmiraBedhSuper User
I have a doubt that your measure is not respecting the filtering context and accidentally resetting or overriding it.
For example, when calculating Red Count, Amber Count, and Green Count, ensure that they properly respect the filter context:
VAR RedCount = CALCULATE([Red Count], KEEPFILTERS(YourTable)) VAR AmberCount = CALCULATE([Amber Count], KEEPFILTERS(YourTable)) VAR GreenCount = CALCULATE([Green Count], KEEPFILTERS(YourTable))Since the measure is being used in a matrix visual, try explicitly defining how the matrix should interact with other visuals.
You can manage the filtering behavior under the "Edit Interactions" options in Power BI.
Since you mentioned that using a calculated column resolves the bypassing issue but doesn't display the image correctly, this suggests the dynamic nature of the measure might be part of the problem. While calculated columns lack flexibility in filtering, a workaround could be to precalculate values or store them in a way that still allows for dynamic rendering without bypassing.
Alternatively, you can create calculated columns for Red Count, Amber Count, and Green Count and a measure for the SVG part, keeping it separate from the counts themselves.
- tarunbisht20001Frequent Visitor
Red Count, Amber Count, and Green Count are not causing the issue actually, when i return total count or either of them instead of SVG it do not causes the issue but when i return any static valu like max width,SVG and all it causes the bypassing.