This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
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
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 27 | |
| 21 | |
| 20 | |
| 20 | |
| 20 |