Having different columns show up as separate bars in a bar graph

[alietzau]

I have a table that has columns that are boolean and I would like to count each of these columns and compare them in a bar graph. My data is structured like this:

Date	UserID	Column A	Column B	Column C
1/1/2020	0001	TRUE	TRUE	TRUE
1/2/2020	0002	TRUE	FALSE	TRUE
1/3/2020	0003	TRUE	TRUE	FALSE
1/4/2020	0004	FALSE	FALSE	TRUE
1/5/2020	0005	FALSE	TRUE	TRUE

I want the graph to look like this photo.

It doesn't seem like it should be impossible to do, but when I try to make the graph, I just get one bar of true or false. Do I need to get a custom visualization or is this impossible?

[mwegener · Accepted solution]

Hi @alietzau 

you could unpivot the columns with Power Query

You may download my PBIX file from here.
Hope this helps.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Anonymous · Accepted solution]

HI @alietzau ,

If you did not want to change your table structure in query editor, you can refer to following formula to create a calculated column to store expand table records from the original table, then you can use new table fields to create charts:

Table = 
SELECTCOLUMNS (
    UNION (
        SUMMARIZE (
            Original,
            Original[Date],
            Original[UserID],
            Original[Column A],
            "CType", "Column A"
        ),
        SUMMARIZE (
            Original,
            Original[Date],
            Original[UserID],
            Original[Column B],
            "CType", "Column B"
        ),
        SUMMARIZE (
            Original,
            Original[Date],
            Original[UserID],
            Original[Column C],
            "CType", "Column C"
        )
    ),
    "Date", [Date],
    "UserID", [UserID],
    "CType", [CType],
    "CValue", [Column A]
)

Regards,

Xiaoxin Sheng

[mwegener · Accepted solution]

Hi @alietzau 

you could unpivot the columns with Power Query

You may download my PBIX file from here.
Hope this helps.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.