Forum Discussion

Lezz81's avatar
Lezz81
Frequent Visitor
3 years ago

Power BI Newbie

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?

 

5 Replies

  • rajulshah's avatar
    rajulshah
    Icon for Resident Rockstar rankResident Rockstar

    Lezz81 ,

    I didn't understand the requirement exactly.

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

  • Lezz81's avatar
    Lezz81
    Frequent Visitor

    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

  • 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's avatar
    Lezz81
    Frequent Visitor

    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's avatar
      rajulshah
      Icon for Resident Rockstar rankResident Rockstar

      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.