Forum Discussion

PowerBI-Curious's avatar
9 years ago
Solved

Unsure what I need... Merging columns OR Visualisations

Hi =)

 

I am in need of a solution and I am not sure what the simplest way to do this. My problem is: 

 

My data has multiple "Critical Risks" and each "Critical Risk" has multiple "Critical Controls" (seperate columns) some of the "Critical Controls" are the same text for "Critical Risks" however different. e.g below

 

Critical Risk - Vehicle Collision and Critical Control - Positive communication

Critical Risk - Vehicle impact and Critical Control - Positive communication

 

At the moment it would count the above as 2 positive communications when really it should be 1 for vehicle collision Pos Com and 1 for vehicle impact pos com.

 

I need to measure the top failing controls on a graph. So I am thinking my options are combine the two columns so I have a new column that says "Vehicle Impact - Positive Communication" and "Vehicle Collision - Positive Communication"

 

OR

 

There may be a way to make my current data set work in the visulisations without manipulating the data.

 

Interested in thoughts on both actions and some info on how to execute either.

 

https://1drv.ms/x/s!ArM9L8ohYGT4gQhszs0ssIc8haUT

 

Thank you,


PowerBI-Curious 

  • They are not currently merged, but I need them merged. I did this really simply this morning with:

     

    Critical Risk/Control = 'CCVS Verification List Report'[Critical Risk] &"|"& 'CCVS Verification List Report'[Critical Control (Verification and Evidence)]

     

    Thanks  =)

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    From your description, what I am missing is why it is counting those two events together.

    • PowerBI-Curious's avatar
      PowerBI-Curious
      Helper I

      They are not currently merged, but I need them merged. I did this really simply this morning with:

       

      Critical Risk/Control = 'CCVS Verification List Report'[Critical Risk] &"|"& 'CCVS Verification List Report'[Critical Control (Verification and Evidence)]

       

      Thanks  =)