Forum Discussion
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_DecklerCommunity Champion
From your description, what I am missing is why it is counting those two events together.
- PowerBI-CuriousHelper 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 =)