Forum Discussion
Advocate IIIVisual Calculations - no drill through, cannot be used with field parameters for measures?
I have a scenario where visual calcaultions in matrix to work the best BUT It seems I cannot combine Field parameters for measures with Visaul calcaultions based on those measure and hide a field paarameter columns inthe visuals, right?
Also I cannot use visual calculation columns for Drill Through based on those columns, am I right?
EduardD
Yes you are right. If you use field parameters + hide columns then apply visual calculation, it is always problematic, on the other hand Drill Through is not supoorted in Visual Calcualtion.
If this helps, ā Mark as Kudos | Mark as Solution| Help Others
5 Replies
Murtaza_GhafoorSuper User
EduardD
Yes you are right. If you use field parameters + hide columns then apply visual calculation, it is always problematic, on the other hand Drill Through is not supoorted in Visual Calcualtion.
If this helps, ā Mark as Kudos | Mark as Solution| Help Others- cengizhanarslan
Visual Calculation columns cannot be used as drillthrough filters. Drillthrough requires actual model columns or measures as the target filter fields. Visual Calculations exist only within the rendering context of the specific visual and have no existence at the model level, so they cannot pass filter context to a drillthrough target page.
- Bipin-Lala
Solution Sage
Hi EduardD,
Field Parameters
Visual Calculations live only within the visual's internal cache, they cannot dynamically re-bind themselves when a Field Parameter swaps the underlying measure.
Instead of using Field Parameters for the measures, you can use a Calculation Group.
Drill Through
Drill Through works by passing a Filter Context from one page to another.
When you try to drill through, Power BI looks for a column in the database to filter by. Since the visual calculation isn't in the database, the link is broken.
If Drill Through is a requirement, you have to move that logic out of the visual and into a DAX Measure.
Let me know if it helps!
v-saisrao-msftCommunity Support
HI EduardD,
Have you had a chance to review the solution we shared by Murtaza_Ghafoor cengizhanarslan EduardD ? If the issue persists, feel free to reply so we can help further.
Thankyou.
- v-saisrao-msft
Hi EduardD,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
