powerbivisualizationpowerquerydata-analysispowerbi-desktop

Change Group By in a Power BI Chart


in Power BI, I have a clustered Bar Chart.

By default, it groups by Date. Is there anyway, that I can group all of the "Brand Mentions" together, Domain Mentioned together etc?

I've included a picture (last picture below), where it shows what I'd like it to look like (this was easy in Excel).

Thanks, Mark

Clustered Chart

Chart Data

Excel version


Solution

  • Are you using a cluster column chart in Power BI?

    enter image description here

    UPDATE:

    Your data:

    enter image description here

    Highlight Date and unpivot other:

    enter image description here

    Updated data table:

    enter image description here