Forum Discussion
Export data contains conditional measurers.
A minor bug I've just come across. I have visuals that contain measures for display and conditional measures which affect the title display and colour. The screenshot below shows how the visual displays if "Show as table" is selected... its as expected.
However, when I export the data to excel using "Export data", the Excel table displays field names for conditional measures applied to the visual title. The following screenshot shows the data.csv file exported from the visual.
Hi Anonymous ,
According to your case requirements, you want to achieve the same format of data displayed in Excel table when you export data to excel using "Export Data" and the same way of displaying visual objects when you select "Show as Table". You can try to publish the report to the PBI service using the Export to CSV feature if it is convenient, where you have several options to choose from, you can try and check if there is an option for you.
Export data from a Power BI visualization - Power BI | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi Anonymous ,
According to your case requirements, you want to achieve the same format of data displayed in Excel table when you export data to excel using "Export Data" and the same way of displaying visual objects when you select "Show as Table". You can try to publish the report to the PBI service using the Export to CSV feature if it is convenient, where you have several options to choose from, you can try and check if there is an option for you.
Export data from a Power BI visualization - Power BI | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Upon further investigation, it appears that the export to excel format is correct and not CSV. The other weird thing is one form of the conditional measure displays in the column while another form does not.
The form of the measure which does not display is.
Display Red Test (Doesn't display in export table) = Var LastFactDate= Max(Fact-Table[Date]) Var FirstVisibleDate = Min(Date[Date]) Return If( FirstVisibleDate > LastFactDate, "Red")The form of the test that does display is;
Display Red Test (Does display in export table) = Var LastFactDate= Calculate( Max(Fact-Table[Date]), RemoveFilters( Fact-Table)) Var FirstVisibleDate = Calculate( Min(Date[Date]), RemoveFilters( Date )) Return If( FirstVisibleDate > LastFactDate, "Red")