Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
Hello Experts, How we create a checkbox table visualization in the report like the attached image?
Solved! Go to Solution.
@koorosh
I cannot think of any straightforward solution but I managed to do something like the below.
My Data:
Created a Measure that shows emoji for 1 and 0, you can insert using Windows key + . for any image you like, also you can find online for additional images.
Measure:
My Matrix :
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hello Fowmy, How are you? Long time. Let's assume we have a table with 6000 rows including two columns. The first is the name of the companies and the second is the services they get. Now we need a matrix that with checkbox shows the services the companies get and not.
@koorosh
I cannot think of any straightforward solution but I managed to do something like the below.
My Data:
Created a Measure that shows emoji for 1 and 0, you can insert using Windows key + . for any image you like, also you can find online for additional images.
Measure:
My Matrix :
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hello Fowmy, How are you? Long time. Let's assume we have a table with 6000 rows including two columns. The first is the name of the companies and the second is the services they get. Now we need a matrix that with checkbox shows the services the companies get and not.
Hi @koorosh
You need to organize your data as I showed in my example to represent every combination of the companies and the services then follow the same measure I shared then use on a matrix.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 57 | |
| 40 | |
| 36 | |
| 18 | |
| 18 |
| User | Count |
|---|---|
| 70 | |
| 69 | |
| 38 | |
| 34 | |
| 23 |