Forum Discussion
Power BI Chart Ploting
I have the following visual generated by my survery tool based on the question below
The data responses are as follows, please note that a responded can choose more than one responses:
I am failing to reproduce a similar plot in Power BI. How can i plot a chart like the above in Power BI. Please note that the data is in the form of a Power BI Service "Dataset" collected using Microsoft Forms and sent to Power BI Service.
Regards,
Chris
I had to use measures calculated as follows for the appropriate measure:
Capsules = CALCULATE(COUNTROWS(), FILTER(ALL(RealTimeData), SEARCH("Capsules",RealTimeData[PMQSDosageForms],, BLANK()) > 0 ))This worked for me.Regards,Chris
5 Replies
Hey Chris,
If you can provide an example of how your data is structured I can give you a more focused and in-depth answer.
In general though you could use the bar chart visual.
Create a measure that counts the number of responses, so something like Count(Table[ID]). Use that measure in the values area of the bar chart Then use the column that contains your risk elements for the legend field.
To get the legend to be on the left hand side you can go into the visualization properties and select left center.
Hopefully that was helpful, if you can send along a data example I can shoot you back some dax and screen shots
Thank you very much, most appreciated. I have recreated the question giving the actual data response.
Regards,
Chris
Chitemerere , difficult to say without data. But what you have seemed like legends. Put that column as a legend. Maybe you skip x-axis
Thank you very much and most appreciated. I have recreated the question with the actual data response.
Regards,
Chris
I had to use measures calculated as follows for the appropriate measure:
Capsules = CALCULATE(COUNTROWS(), FILTER(ALL(RealTimeData), SEARCH("Capsules",RealTimeData[PMQSDosageForms],, BLANK()) > 0 ))This worked for me.Regards,Chris
