Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

True False Column

I have a true false column, What I am looking for is a visulazation of total true and false and percentage of the totla column. Seems easy but I can't get it to work. I am new to Power BI, just st...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    Create a Table Visualization. Drag your true/false column into it and make sure it is set to "Don't Summarize". You click the little drop down arrow next to the field name in the Values area under VISUALIZATIONS. Now, drag the column over into the Values area again. Click the drop down arrow for this one and change to "Count". Now, drag the column over into the Values area again. Click the drop down arrow and change to "Count". For this same one, click the drop down arrow again and choose "Show value as" | "Percentage of grand total". See attached, page 3, Table6

  • Anonymous's avatar
    Anonymous
    7 years ago

    Worked.... Thank you so much!

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

Create a Table Visualization. Drag your true/false column into it and make sure it is set to "Don't Summarize". You click the little drop down arrow next to the field name in the Values area under VISUALIZATIONS. Now, drag the column over into the Values area again. Click the drop down arrow for this one and change to "Count". Now, drag the column over into the Values area again. Click the drop down arrow and change to "Count". For this same one, click the drop down arrow again and choose "Show value as" | "Percentage of grand total". See attached, page 3, Table6

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Worked.... Thank you so much!