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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Top Kudoed Authors