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.

ibarrau's avatar
ibarrau
Super User
1 year ago

Hi. First, it doesn't look like the measure does what you are explaining. So it's kind of tricky. Anyway, make sure you click export current layout when trying to export data. Other options won't show exactly what you are seeing.

For preventing the export to excel for a single report you can do what SamWiseOwl is showing. I you want to prevent it for the whole organization you can change a setting at Admin Portal - Tenant Settings.

I hope that helps