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 information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

 

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.