Forum Discussion

Chitemerere's avatar
Chitemerere
Icon for Responsive Resident rankResponsive Resident
6 years ago
Solved

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:   ...
Need Help
  • Chitemerere's avatar
    Chitemerere
    6 years ago

    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
westwrightj's avatar
westwrightj
Icon for Resolver III rankResolver III
6 years ago

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

Chitemerere's avatar
Chitemerere
Icon for Responsive Resident rankResponsive Resident
6 years ago

Thank you very much, most appreciated.  I have recreated the question giving the actual data response.

 

Regards,

Chris