Report Builder Color transparency setting disabled

[Mixednuts]

Hi,

In my report table, I am trying to set an expression for a column Fill. This provides me with conditional formatting for my report.

I am having a problem with setting the color. In power BI desktop, using a hex string value of "#99E4F660" in table column formatting returns me a light blue color with a 60% transparency setting. 

When I use the same in my report builder expression, it ignores the setting and sets no color on the column

When I try to set to color explicitly, the transparancy controls seem to be disabled.

Any help on how I can make this work?

Thanks,

John

[Anonymous · Accepted solution]

Hi @Mixednuts ,

According to my test, it's by design. Limitations like this do exist in Report Builder/SSRS.

Please take a look at the thread here: Report developers use tricks of overlaying rectangles over the top of each other because SSRS lacks some common features of real report layout and design.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Mixednuts ,

Could you mark my reply as the solution as well?😂

Thanks in advanced!

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @Mixednuts ,

Please follow this official document Power BI Report Builder change log - Power BI | Microsoft Docs to learn about new items, bug fixes, and known issues for each release of Power BI Report Builder.

In addition, you could let the power bi community to know this things and give your votes at power bi site's feedback - Ideas

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi @Mixednuts ,

According to my test, it's by design. Limitations like this do exist in Report Builder/SSRS.

Please take a look at the thread here: Report developers use tricks of overlaying rectangles over the top of each other because SSRS lacks some common features of real report layout and design.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mixednuts · Accepted solution]

Thanks for your feedback Eyelyn!

While I accept that this is not going to be a feature I can use in Paginated Reports, it is strange that the UI includes a facility to set it and then disables it. Maybe a feature yet to come?

Thanks again, John