topic Re: Let enduser control fonts i embeded solution in Report Server

Let enduser control fonts i embeded solution

MagneNordskag — Tue, 11 Oct 2022 10:59:42 GMT

I have a customer the wants to know if it's possible to let an end user of an Web application which embeds a power bi report server report to controll the Fontsize, -color, -type in tables, headings and so on.

From what I can find in the documentation there is no way of doing this by passing in parameters or any other way. Have anyone done something similar?

Re: Let enduser control fonts i embeded solution

d_gosbell — Tue, 11 Oct 2022 21:49:21 GMT

No this is not possible

Re: Let enduser control fonts i embeded solution

Podiumbi — Thu, 13 Oct 2022 02:31:20 GMT

In the Power BI embedded solution I created, I let my users change font types and all of the colors on the app itself.

To change the colors on a report, you would need to get creative.

I created a Parameter and made the values go from 1 to 595.

I created a color table using the enter data feature and added a column for color, code, and id. I downloaded the color codes from the web.

Then I joined the color table to the parameter table on ID.

Then I created a simple measure that grab the color code.

Lastly, I passed the color into the background expression.

Here is the result in a animated gif. To view the full report you can go to https://www.podiumbi.com/powerbi-reporting-software/ and in the footer there is a link for the color picker. If you want the PBIX file just email me.

Re: Let enduser control fonts i embeded solution

MagneNordskag — Thu, 13 Oct 2022 05:13:03 GMT

But this would not work for font-size and other items that that does not have conditional formating right?

Re: Let enduser control fonts i embeded solution

JohanArebert67 — Thu, 13 Oct 2022 12:30:02 GMT

In the Power BI embedded solution I created, I let my users change font types and all of the colors on the app itself.

Here is the result in an animated gif. To view the full report you can go to and in the footer, there are link irons for the color picker. If you want the PBIX file just email me.