Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DAX Calculated Column

Hi All,   I have a situation where in have to represent the data horizontally instead of vertical representation.   Please refer the below table. I have the data currently as mentioned below.   ...
Need Help
Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Anonymous 

Thank you for your message.

I have tried many things to achieve your goal. However, the normal exporting function does not seem to give the result you want.
I think one way is to use external tools (Analyze in Excel).

If you click this in Power BI, the below window (picture in the below) will open. The Excel window will open, and you can create your own style table in excel directly.

If your purpose is to export the wide-style-matrix visualization to excel, I think one way is to create the visualization directly by using "Analyze in Excel" function, and it might be helpful.

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Jihwan_Kim  Yes I tried this option and it works fine but my issue is I've embed the report in my application and there I dont have the option of "Analyse in Excel" so i was trying to figure out if I can do something at the desktop level.