Forum Discussion

adarshsada's avatar
adarshsada
Frequent Visitor
9 months ago
Solved

Field value color errors.

Hi everyone, 

 

I'm trying to create a similar solar rose diagram as seen in the below image using a 3D model (circular surface divided into section which is assigned a particular orientation using the object ID) that in theory would update dynamically based on change in orientation. 


We have one variable which is the change in orientation of the object. What I'm trying to do is that with a change in orientation, I would need the above shown solar rose change to update. However, this update with the field color works when I look at it as a table but now when it is a data style input of the 3D model. 

Unfortunately, I won't be able to share the powerbi file but I can provide some screenshots if needed. 

Thank you in advance. 

Best regards,

A

 

Tips and Tricks
  • adarshsada's avatar
    adarshsada
    9 months ago

    Hi kushanNa ,

    I was able to solve the error with my Rhino 3D model but this with Python script is something that I will take a look next. Thank you for the reference file. 

    Best regards,

    A

7 Replies

    • adarshsada's avatar
      adarshsada
      Frequent Visitor
      9 months ago

      Hi kushanNa ,

      I was able to solve the error with my Rhino 3D model but this with Python script is something that I will take a look next. Thank you for the reference file. 

      Best regards,

      A

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

        Hi adarshsada ,

        We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or 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.

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

    Hi adarshsada ,

    Thank you for reaching out to Microsoft Community.

    To create a dynamic solar rose diagram in Power BI, start by structuring your data with key variables: an orientation variable for angle or direction, section IDs for each slice, and a field value for coloring or intensity, such as energy output. Use Power BI’s custom visuals like 3D Column or Scatter plots, or for more complex 3D shapes, leverage R or Python scripts (e.g., Plotly for 3D polar charts) to represent the solar rose. Ensure the orientation variable is dynamically bound to the visual, so it updates based on changes in the data, with conditional formatting applied to control the section colors. To enable real-time updates, use slicers or bind the orientation variable directly to the custom visual properties. Lastly, optimize for performance by keeping the model simple and loading only essential data.

    Thank you.

     

    • adarshsada's avatar
      adarshsada
      Frequent Visitor
      9 months ago

      Hi v-echaithra,

      Thank you for the response. However, I'm using a 3D Model (a circular Rhino model) similar to below 

      and using the object ID to control the segments (assigned a range of orientation, for example one segment has a range of 10-30°) using it's object ID, following that by adding a color measure under data style(that assigns the color to each object ID based on the solar gains for that range). This works well when viewed as a table but doesnt appear to change dynamically on my 3D model. 

      Thanks in advance