Forum Discussion

JPlancke's avatar
JPlancke
Frequent Visitor
8 years ago
Solved

Summarize Table Header

Hi all,

 

I am fairly new to Power BI and currently struggling to create a visualization.

 

The data I am visualizing is about insurances and Risks associated to these insurances. For this we have a Summary table where each unique insurance represents a row. The first column is the unique identifier (insurance number) and the following columns are the risk columns. For each insurance, the risk is flagged via a 1 or 0 (1 = flag set, 0 = no flag) in each risk column. 

 

I am looking to visualize via:

 

A bar chart where each value on the X-axis is a risk and the bar itself should represent the number of insurances that have this specific risk. 

 

But there is a catch to it: If I select a specific insurance (e.g. from a table) I want this bar chart to visualize the specific risks that were flagged for that insurance. So, this has to be visualized based on my Summary Table (not via an intermediary table where the totals for each risk are calculated, since this does not allow me to filter down any further based on an individual (or group of) insurance(s) ).

Refer to the image below for a basic example done in Excel:

 

Thanks a lot in advance guys!

  • Hi

     

    If you are looking for somthing like this,

     

    you can use unpivot columns in power query and then use that as a source for this chart.

     

2 Replies

  • dilumd's avatar
    dilumd
    Impactful Individual

    Hi

     

    If you are looking for somthing like this,

     

    you can use unpivot columns in power query and then use that as a source for this chart.

     

    • JPlancke's avatar
      JPlancke
      Frequent Visitor

      Thanks a lot dilumd!

       

      The problem is indeed solved by pivotting the table and building the visualization based on the new source. 

       

      Yours best,

       

      JP