Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
i want to create a heatmap in a table
| user id | log in date |
| 1 | 1/1/2020 |
| 2 | 1/1/2020 |
| 1 | 3/1/2020 |
| 2 | 4/1/2020 |
| 1 | 5/1/2020 |
| 2 | 5/1/2020 |
| 3 | 2/1/2020 |
i want to creat counting of how many days left to the trail (trail have 30 days per user)
i want to get in the end somting like this
| date (first log in) | 30 | 29 | 28 | 27 | 26 | 25 | ..... |
| 1/1/2020 | 2 users | 1 user | 1 user | 2 users | |||
| 2/2/2020 | 1 user |
thanks!
@rco123456
Need more explanation and propper data sample and the expected results to work out a good solution.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 10 | |
| 5 | |
| 5 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 24 | |
| 11 | |
| 9 | |
| 6 | |
| 6 |