Forum Discussion

adarshsada's avatar
adarshsada
Frequent Visitor
9 months ago
Solved

Assigning a calculated column as field value

Hi everyone,    I currently have a Rhino model (2D surface divided into multiple sections as seen in the below image) and I'm using it's object ID to control each section.  What Im trying to...
Need Help
  • v-echaithra's avatar
    v-echaithra
    8 months ago

    Hi PhilipTreacy ,

    This happens because the 3D visual is not passing the Obj ID filter to the other visuals. For the rectangles to respond correctly, both visuals must use the same Obj ID field, and the model must allow the filter to flow between them.

    Confirm both visuals use the same Obj ID. The rectangles visual uses Rose Chart[Obj ID]. The 3D visual uses Rhino[Obj ID], these need to represent the same IDs, otherwise no cross-filtering can occur.

    Check the data model relationship. Make sure there is a relationship between:
    Rhino[Obj ID] → Rose Chart[Obj ID]
    If this relationship does not exist, or is inactive, then clicking the 3D model will not filter the rectangles.

    Enable visual interactions. Even if the relationship exists, Power BI might be blocking interaction between the visuals.

    Select the 3D visual
    Go to Format → Edit interactions
    Ensure the rectangles visual is set to Filter (not “None” or “Highlight”)
    This ensures the 3D model can send filters to the rectangles visual.

    Hope this helps.
    Thank you.

DataNinja777's avatar
DataNinja777
Super User
8 months ago

Hi adarshsada ,

 

You can achive your required output by using a measure to assign color dynamically instead of the calculation column which can only pre-calculate the value.  You can write a measure like below:

Color_Measure = 
VAR _gain = SELECTEDVALUE('Table'[SG])
RETURN
SWITCH(
    TRUE(),
    ISBLANK(_gain) || _gain = 0, "#FFFFFF",
    _gain <= 40, "#9ECF84",
    _gain <= 45, "#FEC20E",
    "#DD5529"
)

 Then you can assign that measure in the fill section of the shape visual.  

 

 

This ensures your shape color is dynamically switchable by slicer selections.  

 

I have attached an example pbix file for your reference.

 

Best regards,