cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Visualizing textual data, like YES/NO questions

Howdy folks - first post! Couldn't find the answer to this in the forums, and not sure I can even ask it right, but here goes.

 

I have a spreadsheet similar to this:

 

            2014   2015

Site 1    YES     YES

Site 2    NO     YES

Site 3    YES     NO

 

I'd like a visualization / horiz bar chart that would simply show each site, with the two years as sub-groupings under each site, then a solid 100% bar that was either red for NO or green for YES. Or any variation, I'm open, but I'm getting stuck on the YES/NO fields simply getting counted, which doesn't help me (unless I convert the YES's to 0 and NO's to 1 or something). 

 

Any thoughts on how to approach this? Let me know if I can clarify or explain in more detail. 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate I
Advocate I

Re: Visualizing textual data, like YES/NO questions

I've dealt with this myself (though in my case it was TRUE/FALSE values).  Here's how I solved it:

 

 - Created a new calculated field called "Achieved or Missed" (you should use something appropriate for your data), assign it a numerical value of '1' whenever the original field's value is 'Yes' or a numerical value of '0' whenever the original field's value is 'No'

- Create 1 new measure called '% Achieved' --- SUM('Achieved or Missed') / COUNT('Achieved or Missed')

- Create 1 new measure called '% Missed' --- (COUNT('Achieved or Missed') - SUM('Achieved or Missed')) / COUNT('Achieved or Missed')

- Use a Stacked Bar (or Column) chart and plot the 2 measures.

 

 

View solution in original post

3 REPLIES 3
Highlighted
Advocate I
Advocate I

Re: Visualizing textual data, like YES/NO questions

I've dealt with this myself (though in my case it was TRUE/FALSE values).  Here's how I solved it:

 

 - Created a new calculated field called "Achieved or Missed" (you should use something appropriate for your data), assign it a numerical value of '1' whenever the original field's value is 'Yes' or a numerical value of '0' whenever the original field's value is 'No'

- Create 1 new measure called '% Achieved' --- SUM('Achieved or Missed') / COUNT('Achieved or Missed')

- Create 1 new measure called '% Missed' --- (COUNT('Achieved or Missed') - SUM('Achieved or Missed')) / COUNT('Achieved or Missed')

- Use a Stacked Bar (or Column) chart and plot the 2 measures.

 

 

View solution in original post

Highlighted
New Member

Re: Visualizing textual data, like YES/NO questions

Thanks Phil. Clever approach, I've gotten closer based on your input, so thanks. The multiple years are adding to the complexity for this novice. I'll keep at it!

Highlighted
Advocate I
Advocate I

Re: Visualizing textual data, like YES/NO questions

Frank,

 

Glad it helped. 🙂

 

As to the 'Years' ... if I understood your data correctly, you should be able to put that column in the 'Axis' of the Stacked Bar chart and have it display the Yes/No % bar for each individual year.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors