Power BI Newbie

[Lezz81]

Hi All,

I am tasked with creating a report that will show the regulatory compliance.

I have multiple sharepoint list. that is in this format. Listed below are the headers

| section number | Descrption  | Fully Complied | Partially Complied | Not Compiled | NA |

1. How to do up a chart with multiple headers?

[Lezz81]

Hi @DataVizzer.,

I would like to create a bar chart that will show the following only for Section 3

1. % Fully Done 

2. % Partially Done 

3. % Not Done 

4. % NA

Can you plaese assit?

Thank You

regards,
Lezz81

[rajulshah]

@Lezz81 

Click on the bar visual, drag 'Section" in X-axis and drag all the % values in Y-axis. Maybe that would solve the problem.

[DataVizzer]

Hi, what kind of diagram do you want to create? Could you provide more details?

In general:

There are different ways to create a chart with multiple headers in Power BI, depending on your data structure and desired output. Here are some possible solutions:

• You can use a matrix visualization and add multiple fields to the columns bucket. 
• You can use a table visualization and rearrange your data into a single heading format using Power Query Editor.
• You can use a custom visual such as Multi KPI, Multi Row Card, or Table Heatmap that supports multiple headers (AppSource or Python / R)

If I could help you please mark the answer as a solution.

[Lezz81]

Basically I got a list that I have shown below that has to be translated to a dashboard.

The sample excel is attached along.

I am now doing up the dashboard and I am lost on how to do up a dashboard.

1. How can I do up a widget that will show me the [% fully done , % partially done , % not done & % NA] all into a single bar chart?

Can someone please help me with this?

Thank you

Regards,
Lezz81

[rajulshah]

@Lezz81 ,

I didn't understand the requirement exactly.

Do you want to plot the columns? 
You can use table/matrix visual for that.