Forum Discussion
Visualizations: Grouped bar chart (help)
Still a newbie at PBI, but I've been laboring the past few days learning DAX and tables. So now I've finally created a very large table with many measures and calculated columns, but I want to display one row from 12 columns grouped like this:
I should point out that all of the data I need exists in a single table and is organized by date. So, for example, if you went to the row for June 2018 and scanned accross the columns you'd find (among many others) the measures for Cost Center PPM, Warranty PPM, etc. as well as the calculated 3MRA and 12MRA values.
So everything is already there, in one row, but how to I create a column visual that (using a slicer) will extract those specific 12 columns from that selected row and group them as shown.
Is it possible?
5 Replies
Hi Anonymous,
Although you say that the information is all there in your table be aware that in order to have the correct results sometimes the information needs to be in a single column. To what I can understand from your question you have several measures (3MRA, 12 MRA) and then several columns the PPM Categorys. In order to achieve this look and feel you need to make the unpivot of the PPM categorys to single column and that will allow you to place the Category on the X-axis then add the measures on the values.
However as I said the question is not clear.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of Greg_Deckler).Regards,
MFelix
You are correct. As noted, I am a major newbie in PBI and still think like Excel, so my table looks like an Excel data table would. Categories are in columns, and dates are from top to bottom. All data from a given year/month exists in a single row accross.
My actual data has a lot of proprietary info in it, but here is a sampe of what my table looks like (it actually has about 6x this many columns):
Can it be done arranged like this?
P.S. I am still trying to convert my thinking process to the Power BI way.
Hi Anonymous
Based on my test, to get the visual like the screenshot, your table should structure as below
From you second screenshot, your table is not like this, i'm afraid it is neccessary to change the model of your table in Edit Queries.
It would be better to share a table with me.
Best Regards
Maggie
