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
Hi there.
I i want to make a report with data like this. What would be the best layout in Power Bi to use?
Matrix? some Calendartable or something else?
| Info | Mon | Tue | Wed | Thur | Fri | Sat | Sun | |
| Employee1 | Data1 | Decimal | Decimal | |||||
| Data2 | Text | Text | Etc. | |||||
| Data3 | Date | Date | ||||||
| Employee2 | Data1 | Decimal | Etc. | |||||
| Data2 | Text | |||||||
| Data3 | Date | |||||||
| Employee3 | Data1 | Decimal | ||||||
| Data2 | Text | |||||||
| Data3 | Date | |||||||
| Etc. |
I would like Data1, Data2, Data3 to be on the same row if possible, even though they have different formats? Or maybe as a '+' icon that will unfold 3 rows(form 1 initially).
All suggestions much appriciated, thanks.
Solved! Go to Solution.
You can use showon row property of values
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
You can use showon row property of values
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |