Calendar Heat Map

[powerbiexpert22]

Is there a way to acheive below reuirement

1. Show calendar dates as Heat map with color represent number of Sales , example red color shows less number of sales and green shows high number of sales

2. Once user click on specific calendar date then it should show underlying data in tabular format in the same report, example,  orderID, ProductID, Sales etc

[powerbiexpert22]

@lbendlin I am stuck in displaying multiple metrics in heat map box

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[lbendlin]

yes, with conditional formatting and tooltips.  What have you tried and where are you stuck?