Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
SteveD
Advocate II
Advocate II

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.

  

SteveD_0-1672972043212.png

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.

SteveD_1-1672972256601.png

 

  

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @SteveD ,

 

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.

View solution in original post

3 REPLIES 3
SteveD
Advocate II
Advocate II

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")
v-yangliu-msft
Community Support
Community Support

Hi  @SteveD ,

 

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.

Export data and select file type as CSV appears to fix the issue.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors