cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
VosInnieBos
Frequent Visitor

Transparent code #FFFFFF00 in Dax results in "Error occurred while rendering the report"

Hi all 

 

I am hoping someone can help me. 

Im trying to use a DAX formula to return either Transparent (#FFFFFF00) or a color.

Then I use this DAX to conditionally fill a button. 

 

However when I use the 8 digit Hex code I get an error rendering the report.

When I use a 6 digit Hex code it works, but Im unable to make the button transparent.  

 

I used this video to get me to this point: (3) Making (some) things transparent in Power BI - YouTube

Any help will be greatly appreciated!

 

My formula is: 

VosInnieBos_1-1618332498787.png

 

 My Error:
VosInnieBos_0-1618332434101.png

 

1 ACCEPTED SOLUTION
Watsky
Continued Contributor
Continued Contributor

Hey @VosInnieBos, it appears to be an issue only with Fill. What about turning off Fill and adding your measure to the background color?

 


Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

View solution in original post

2 REPLIES 2
Watsky
Continued Contributor
Continued Contributor

Hey @VosInnieBos, it appears to be an issue only with Fill. What about turning off Fill and adding your measure to the background color?

 


Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

View solution in original post

Thank you! That worked!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors