Heat Map alternate column values

[kalyani]

Hello,

In Heat Map, I'm trying to achieve this, but not sure if this is possible. Can you please help me.

In Location (ID) - Given City name and Group by Country name. In the values I want to display all the $ (amount) columns in my table, one by one based on the selections. There are Sales ($), Lost Sales ($) and Excess Sales($) amount columns in my table.

If I select Sales column, I want to see the Sales ($) values and if I select Lost Sales column, want to see Lost Sales($) values and if I select Excess Sales column, want to see the Excess Sales ($) values.

If I drag the columns in Chicklet slicer, I can see the values of the column, but it should be sum(column values) on one click column name in slicers.

Is it possible, or any alternatives for this?

Regards

Kalyani L

[v-piga-msft]

Hi  @kalyani,

In Location (ID) - Given City name and Group by Country name. In the values I want to display all the $ (amount) columns in my table, one by one based on the selections. There are Sales ($), Lost Sales ($) and Excess Sales($) amount columns in my table.

---

By my test, you may cannot put severial columns in the Value. It only support a single column in the value, if you put another, the previous one will be replace.

If you have additional help, you could have a support from  here.

Best Regards,

Cherry

[kalyani · Accepted solution]

Thank you for your suggestions, even I tried the same. As you said, only one value can be asigned to the map, and if I assign a new value hte old value will be replaced.

Thanks

[v-piga-msft]

Hi @kalyani,

If we help you, please accept the reply as solution to your question so that people who may have the same question can get the solution directly.

Best Regards,

Cherry