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.

minhuan's avatar
minhuan
Regular Visitor
1 year ago

Thanks a lot, When I use export current layout， it still doesn't work. 

I can't disable all export, so I think I need to use admin portal to control export type. I think this is a feature bug.

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

Hi minhuan ,

This isn’t a bug, even with Export current layout, Power BI exports the underlying model values before formatting. That’s why <10> is replaced by the original number.

If you want <10> to show up in the export, make the measure return text in DAX, such as:

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

This makes the value text so the export matches the visual. If you need numeric sorting, create a second numeric column or measure and use Sort By Column.

To restrict export types, go to Admin Portal - Tenant settings - Export and sharing settings and limit formats (like CSV) for certain security groups.