Forum Discussion
stewarte18
6 years agoRegular Visitor
Creating Bar Chart with Metric data
I'm newer to Power BI. I'm trying to create a simple Bar Chart that you would put together in Excel (See below Total) using Survey Audit Data. The Survey question asks What was Missing? The person...
Ashish_Mathur
6 years agoSuper User
Hi,
The raw data will have to be transformed using the Query Editor. Share data here which can be pasted in an MS Excel file.
stewarte18
6 years agoRegular Visitor
I need to build a simple bar chart using the table below. However, in Power BI, there is no relationship between the x-axis so the visual appears incorrect. This is a multi-select question so the columns cannot be merged in power query.
- Ashish_Mathur6 years agoSuper User
Hi,
In the Query Editor, right click on the first column and select "Unpivot other column". You may delete the attribute column. Now create the visual.