Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
have created a measure 'rate' in my report . I have set the formatting of this measure to dynamic format
. 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.
can someone help me to solve this is problem?
Solved! Go to Solution.
You could create a paginated report to export your data. Those allow very fine grained control over the layout and formatting.
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.
User | Count |
---|---|
6 | |
4 | |
2 | |
2 | |
2 |