Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
esraa_eissa
New Member

Percentage formatting issues when exporting to excel in power bi report server

 have created a measure 'rate' in my report . I have set the formatting of this measure to dynamic format

IF(
    SELECTEDMEASURE() = "---",
    "---",
    IF(
        ISNUMBER(SELECTEDMEASURE()),
        IF(
            SELECTEDMEASURE() <> INT(SELECTEDMEASURE()),
          "#0.00%",
            "#0%"
        )
    )
)

. This works perfectly fine in the visual.
However when I publish up to the sever and then export into excel the % changes to a decimal number.

esraa_eissa_0-1716286222100.png

can someone help me to solve this is problem?

 

1 ACCEPTED SOLUTION

You could create a paginated report to export your data. Those allow very fine grained control over the layout and formatting.

View solution in original post

3 REPLIES 3
d_gosbell
Super User
Super User

The on-prem report server does not support exporting with the current layout (which includes the formatting) see Compare Power BI Report Server and the Power BI service - Power BI | Microsoft Learn It only supports exporting summarized data which does not include the formatting.

okay thanks.
Are there any workarounds I can do to solve my issue?

You could create a paginated report to export your data. Those allow very fine grained control over the layout and formatting.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors