Forum Discussion

minhuan's avatar
minhuan
Regular Visitor
1 year ago
Solved

Powerbi Service Export Issue--Export Excel

Hi   I create a measure, _x=switch(TRUE(),ISBLANK([measure]),BLANK(),[measure]<10,[measure]), when data <10, it will show '<10' in the table. But I find that when I export data from service in 'Exc...
Need Help
  • anilgavhane's avatar
    anilgavhane
    11 months ago

    minhuan Workaround: Preserve Display Formatting in Export

    To ensure that Excel shows "<10" instead of the actual number, you can modify your measure to return text instead of numeric values:

     

    _x = SWITCH( TRUE(), ISBLANK([measure]), BLANK(), [measure] < 10, "<10", FORMAT([measure], "General") )

     

    This forces Power BI to treat the output as text, which will be preserved during export. However, note that this may limit sorting or aggregation in visuals.

v-sshirivolu's avatar
v-sshirivolu
Community Support
1 year ago

Hi minhuan ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

 

v-sshirivolu's avatar
v-sshirivolu
Community Support
11 months ago

HI minhuan ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.