Hi @devika,
A forest plot, also known as a blobbogram, is a type of chart that is commonly used to display the results of a meta-analysis. It is a combination of a bar chart and a scatter plot, and it allows for the display of multiple groups of data in a single chart.
To produce a forest plot in Power BI, you will need to use a custom visual. There are several custom visuals available that can be used to create a forest plot, such as the "Forest Plot" visual by Microsoft or the "Forest Plot" visual by OKViz.
To use a custom visual, you will first need to install it in Power BI. You can do this by going to the "File" menu, selecting "Import", and then choosing the custom visual you want to use. Once the custom visual is installed, it will be available in the "Visualizations" pane.
Next, you will need to prepare your data for the forest plot. This will typically involve grouping your data into categories and calculating the summary statistics for each group, such as the mean and standard deviation. You will also need to format your data so that it matches the data structure required by the custom visual.
Once your data is prepared, you can add the custom visual to your report and configure it to display your data. This will typically involve specifying which columns of your data should be used for the categories, the summary statistics, and other settings.
After configuring the custom visual, you should be able to see the forest plot in your report. You can then use the formatting options available in Power BI to customize the appearance of the forest plot, such as changing the colors and labels.
Hope this helps! 🙂
Kind Regards,
Sahir
