Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
I would like to know if it is possible to make flow chart (visual) from the below data table, that looks like the flow chart as below the data table
| Client Category | CD4 Test | CD4 <200 | CrAG Done | Pos CrAG | LAM Done | Pos LAM | CSF CrAg Done | Pos CSF CrAG |
| Already on ART | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Initial Clients | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Already on ART | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Initial Clients | 18 | 15 | 15 | 1 | 15 | 7 | 4 | 0 |
I would like the chart to look as below:
Been trying but I seem not know the best way around it.
Thanks in advance
The answer depends on whether you're expecting the nodes & connections in your flowchart to be static or dynamic.
If static, you can make your own tree out of separate cards & connect them with lines to make the visual. You'll just need to make a measure for each card which defines the value in that node, but that shouldn't be too difficult
If dynamic, then I would choose "get more visuals" from the bottom of the selection in Power BI and then search for "tree". This will give you several options for visuals, but you will have to restructure your data to make them work: your current table does not define which node connects to which, or which level of the hierarchy anything is in.
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 |
|---|---|
| 44 | |
| 43 | |
| 38 | |
| 18 | |
| 16 |
| User | Count |
|---|---|
| 67 | |
| 63 | |
| 30 | |
| 30 | |
| 23 |