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.

adarshsada's avatar
adarshsada
Frequent Visitor
9 months ago

Hi PhilipTreacy and all,

 

I'm reopening this issue as I believe these's a better way of solving the problem instead of adding a button slicer. I've linked my powerBI file as well ( https://www.swisstransfer.com/d/b3e47656-e9e1-435b-b1e7-e3d0603f5926 ). 
What I'm trying to do is trying to control the retangle using the 3D model (windows) but it does not change dynamically. 


However, it works when I have a button slicer with the ID names. 

This is good for a small number of ID's but isn't logical when I have alot of them. Is there a way to make it work by selecting the "ID's" in my 3D model?

 

  • v-echaithra's avatar
    v-echaithra
    Community Support
    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.

    • adarshsada's avatar
      adarshsada
      Frequent Visitor
      8 months ago

      Hi v-echaithra,

      Thank you so much! The interaction between the rectangle and the 3D model was set to Highlight and hence it wasn't working. Now that I set it to Filter, it works as it should. The issue is now solved. I really appreciate your help.

       

      Best,

      A

      • v-echaithra's avatar
        v-echaithra
        Community Support
        8 months ago

        Hi adarshsada ,

        Thank you for confirming that issue has been resolved. If further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

        Best Regards,
        Chaithra E.