Forum Discussion
How to apply conditional formatting while exporting the data into an excel file using query.
No, as I said, the queries generated have no formatting at all, just data. Then the visual author translates that data into the conditional formatting you see. You'd have to apply that same logic on the raw data you extracted.
Power BI queries are just data. 100% of any formatting is done exclusively by the visual, whether it is you changing colors in a bar chart, the background color, or conditional formatting. The Vertipaq engine you query - in the viz, or via Power Automate - has no clue about formatting.
Thankyou edhans for the response.
Do we have any other way to apply conditional formatting before we export the data?
No, as I said, the queries generated have no formatting at all, just data. Then the visual author translates that data into the conditional formatting you see. You'd have to apply that same logic on the raw data you extracted.
Power BI queries are just data. 100% of any formatting is done exclusively by the visual, whether it is you changing colors in a bar chart, the background color, or conditional formatting. The Vertipaq engine you query - in the viz, or via Power Automate - has no clue about formatting.