Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Heatmap matrix from excel

Hello guys,   I'm trying to represent a heatmap matrix that I have stored in excel sheet in PBI but I'm facing some problems. The sample matrix looks like that:   Screenshot:     Data: ...
Need Help
Tips and Tricks
v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Your data table is too confusing. It is impossible to create your sample matrix diagram from your data table, so you must manually modify your data table.

Or, does your data table come from your pivot table in Excel? Don't do like this, import the original data directly  to Power BI Desktop, then, create visualization in Power BI Desktop.

In addition, it's impossible to realize your sample matrix in current version( 2.76.5678.782 64-bit (December 2019)). 

 

Best regards,
Lionel Chen

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.