Forum Discussion
Visualizations: Grouped bar chart (help)
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.
I made this as big as it allows, but to my eye it seems unreadable. Are you able to see the text?
Hi Anonymous,
Can you share your file? maybe by private message.
Regards,
MFelix