Forum Discussion
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...
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.
Excel export shows raw values, not formatted <10 → this is a Power BI limitation (formatting isn’t preserved).
To disable export for a report:
Report settings → Export data = Off, or
Admin portal → Tenant settings → Export data (scope to users/workspaces).