Field value color errors.

[adarshsada]

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

[kushanNa]

Hi   @adarshsada 

Are you looking for an output similar to this?

If so, I have created it using the Power BI built-in Python visual, as Patrick mentioned here: https://www.youtube.com/watch?v=3_DOF_qjguA.

Please find attached the sample PBIX file I created for your reference.

[adarshsada · Accepted solution]

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]

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.

[adarshsada]

Hi @v-echaithra , 

Thank you for following up. I've reopened this concern as I'm hoping to get a much accurate solution. I've posted a new reply under this question Re: Assigning a calculated column as field value - Microsoft Fabric Community with my powerbi file. 

Thanks in advance,

A

[v-echaithra]

Hi @adarshsada ,

Thank you for the update. I see that the issue has been resolved in the other thread Solved: Re: Assigning a calculated column as field value - Microsoft Fabric Community you raised, and I hope that resolves the concern here as well. If you still need further assistance, please let us know, we’re available to support you and committed to helping you reach a resolution.

Best Regards,
Chaithra E.

[v-echaithra]

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]

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