Ggtcf

Extra alignment tab has been changed to cr. } using table, tabular and resizebox

Is there any way to damage Intellect Devourer(s) when already within a creature's skull?

They call me Inspector Morse

Unreachable code, but reachable with exception

Solving "Resistance between two nodes on a grid" problem in Mathematica

How could our ancestors have domesticated a solitary predator?

Should I take out a loan for a friend to invest on my behalf?

Single word request: Harming the benefactor

Good for you! in Russian

Why is there a voltage between the mains ground and my radiator?

Why does Captain Marvel assume the people on this planet know this?

Do Bugbears' arms literally get longer when it's their turn?

Can't find the Shader/UVs tab

Examples of a statistic that is not independent of sample's distribution?

Algorithm to convert a fixed-length string to the smallest possible collision-free representation?

How do you like my writing?

What is the chance of making a successful appeal to dismissal decision from a PhD program after failing the qualifying exam in the 2nd attempt?

Why doesn't this Google Translate ad use the word "Translation" instead of "Translate"?

How strictly should I take "Candidates must be local"?

PTIJ: Why can't I eat anything?

Is there an elementary proof that there are infinitely many primes that are *not* completely split in an abelian extension?

infinitive telling the purpose

Do f-stop and exposure time perfectly cancel?

Reverse string, can I make it faster?

PowerBI - combining values and showing them in charts

0

I am fairly new at PowerBI but want to use it within our Organisation a lot more frequently to get a better insight into our data.
Here is what i am currently struggling with:

I am trying to combine several individual datasets into one Group so i can Show them in a graph and compare them to other (potentially not combined Groups).
I have tried the grouping function but this just doesn't Group any values at all, and the Graphs do not Change. Below is a pic for Illustration.

Any help is greatly appreciated

thankx!
BR
AJ

powerbi

share|improve this question

edited Mar 7 at 7:47

Roman Patutin

1,69021419

asked Mar 7 at 7:38

AndyJamesAndyJames

32

New contributor

AndyJames is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I am fairly new at PowerBI but want to use it within our Organisation a lot more frequently to get a better insight into our data.
Here is what i am currently struggling with:

I am trying to combine several individual datasets into one Group so i can Show them in a graph and compare them to other (potentially not combined Groups).
I have tried the grouping function but this just doesn't Group any values at all, and the Graphs do not Change. Below is a pic for Illustration.

Any help is greatly appreciated

thankx!
BR
AJ

powerbi

share|improve this question

edited Mar 7 at 7:47

Roman Patutin

1,69021419

asked Mar 7 at 7:38

AndyJamesAndyJames

32

New contributor

AndyJames is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I am fairly new at PowerBI but want to use it within our Organisation a lot more frequently to get a better insight into our data.
Here is what i am currently struggling with:

I am trying to combine several individual datasets into one Group so i can Show them in a graph and compare them to other (potentially not combined Groups).
I have tried the grouping function but this just doesn't Group any values at all, and the Graphs do not Change. Below is a pic for Illustration.

Any help is greatly appreciated

thankx!
BR
AJ

powerbi

share|improve this question

edited Mar 7 at 7:47

Roman Patutin

1,69021419

asked Mar 7 at 7:38

AndyJamesAndyJames

32

New contributor

AndyJames is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited Mar 7 at 7:47

Roman Patutin

1,69021419

asked Mar 7 at 7:38

AndyJamesAndyJames

32

New contributor

AndyJames is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited Mar 7 at 7:47

Roman Patutin

1,69021419

asked Mar 7 at 7:38

AndyJamesAndyJames

32

New contributor

AndyJames is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited Mar 7 at 7:47

Roman Patutin

1,69021419

edited Mar 7 at 7:47

Roman Patutin

1,69021419

asked Mar 7 at 7:38

AndyJamesAndyJames

32

New contributor

AndyJames is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked Mar 7 at 7:38

AndyJamesAndyJames

32

1 Answer
1

active

oldest

votes

0

Just define a new column with your needed category. On the left pane, go to Data > Modelling > New Column and write the following expression (assuming in YourDeptColumn values are strings):

NewColumn = IF(OR(YourTable[YourDeptColumn] = "Dept.1"; 
 YourTable[YourDeptColumn] = "Dept.2";
 YourTable[YourDeptColumn] = "Dept.3"
 );
 "Dept 1+2+3"; 
 "Dept 4"
 )

This is the result:

 YourDeptColumn NewColumn
 Dept.1 Dept 1+2+3
 Dept.2 Dept 1+2+3
 Dept.3 Dept 1+2+3
 Dept.4 Dept 4
 Dept.1 Dept 1+2+3

Now put the NewColumn in your chart as category and the YourDeptColumn as color shade.

share|improve this answer

answered Mar 7 at 8:01

StrawberryshrubStrawberryshrub

1,4962517

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for the immediate reply! Does this allow me then subsequently add up the "x hours" from the individual Depts.? And do i need the part for "Dept 4" ? I should mention i have like 20 other depts i don't want to sum
  
  – AndyJames
  Mar 7 at 10:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  EDIT: thanks this worked lovely, but It seems as if i cannot combine more than two "OR" statements. Do i have to combne several OR-columns to get where i need to be?
  
  – AndyJames
  Mar 7 at 10:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes you are right, the docu says it just supports two arguments in the OR(). You can either stack the OR() function or you use a Switch() function. Here is a reference for the switch: docs.microsoft.com/en-us/dax/switch-function-dax
  
  – Strawberryshrub
  Mar 7 at 13:21
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Great, thanks! Will defo give this a try! This seems to be like the "IFS" function from excel, or am I mistaken? EDIT: Just tried it and it seems to be working as intended
  
  – AndyJames
  Mar 7 at 14:22
  
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

AndyJames is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55038413%2fpowerbi-combining-values-and-showing-them-in-charts%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Just define a new column with your needed category. On the left pane, go to Data > Modelling > New Column and write the following expression (assuming in YourDeptColumn values are strings):

NewColumn = IF(OR(YourTable[YourDeptColumn] = "Dept.1"; 
 YourTable[YourDeptColumn] = "Dept.2";
 YourTable[YourDeptColumn] = "Dept.3"
 );
 "Dept 1+2+3"; 
 "Dept 4"
 )

This is the result:

 YourDeptColumn NewColumn
 Dept.1 Dept 1+2+3
 Dept.2 Dept 1+2+3
 Dept.3 Dept 1+2+3
 Dept.4 Dept 4
 Dept.1 Dept 1+2+3

Now put the NewColumn in your chart as category and the YourDeptColumn as color shade.

share|improve this answer

answered Mar 7 at 8:01

StrawberryshrubStrawberryshrub

1,4962517

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for the immediate reply! Does this allow me then subsequently add up the "x hours" from the individual Depts.? And do i need the part for "Dept 4" ? I should mention i have like 20 other depts i don't want to sum
  
  – AndyJames
  Mar 7 at 10:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  EDIT: thanks this worked lovely, but It seems as if i cannot combine more than two "OR" statements. Do i have to combne several OR-columns to get where i need to be?
  
  – AndyJames
  Mar 7 at 10:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes you are right, the docu says it just supports two arguments in the OR(). You can either stack the OR() function or you use a Switch() function. Here is a reference for the switch: docs.microsoft.com/en-us/dax/switch-function-dax
  
  – Strawberryshrub
  Mar 7 at 13:21
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Great, thanks! Will defo give this a try! This seems to be like the "IFS" function from excel, or am I mistaken? EDIT: Just tried it and it seems to be working as intended
  
  – AndyJames
  Mar 7 at 14:22
  
  

  
  
  
  

add a comment | 

0

Just define a new column with your needed category. On the left pane, go to Data > Modelling > New Column and write the following expression (assuming in YourDeptColumn values are strings):

NewColumn = IF(OR(YourTable[YourDeptColumn] = "Dept.1"; 
 YourTable[YourDeptColumn] = "Dept.2";
 YourTable[YourDeptColumn] = "Dept.3"
 );
 "Dept 1+2+3"; 
 "Dept 4"
 )

This is the result:

 YourDeptColumn NewColumn
 Dept.1 Dept 1+2+3
 Dept.2 Dept 1+2+3
 Dept.3 Dept 1+2+3
 Dept.4 Dept 4
 Dept.1 Dept 1+2+3

Now put the NewColumn in your chart as category and the YourDeptColumn as color shade.

share|improve this answer

answered Mar 7 at 8:01

StrawberryshrubStrawberryshrub

1,4962517

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for the immediate reply! Does this allow me then subsequently add up the "x hours" from the individual Depts.? And do i need the part for "Dept 4" ? I should mention i have like 20 other depts i don't want to sum
  
  – AndyJames
  Mar 7 at 10:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  EDIT: thanks this worked lovely, but It seems as if i cannot combine more than two "OR" statements. Do i have to combne several OR-columns to get where i need to be?
  
  – AndyJames
  Mar 7 at 10:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes you are right, the docu says it just supports two arguments in the OR(). You can either stack the OR() function or you use a Switch() function. Here is a reference for the switch: docs.microsoft.com/en-us/dax/switch-function-dax
  
  – Strawberryshrub
  Mar 7 at 13:21
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Great, thanks! Will defo give this a try! This seems to be like the "IFS" function from excel, or am I mistaken? EDIT: Just tried it and it seems to be working as intended
  
  – AndyJames
  Mar 7 at 14:22
  
  

  
  
  
  

add a comment | 

Just define a new column with your needed category. On the left pane, go to Data > Modelling > New Column and write the following expression (assuming in YourDeptColumn values are strings):

NewColumn = IF(OR(YourTable[YourDeptColumn] = "Dept.1"; 
 YourTable[YourDeptColumn] = "Dept.2";
 YourTable[YourDeptColumn] = "Dept.3"
 );
 "Dept 1+2+3"; 
 "Dept 4"
 )

This is the result:

 YourDeptColumn NewColumn
 Dept.1 Dept 1+2+3
 Dept.2 Dept 1+2+3
 Dept.3 Dept 1+2+3
 Dept.4 Dept 4
 Dept.1 Dept 1+2+3

Now put the NewColumn in your chart as category and the YourDeptColumn as color shade.

share|improve this answer

answered Mar 7 at 8:01

StrawberryshrubStrawberryshrub

1,4962517

NewColumn = IF(OR(YourTable[YourDeptColumn] = "Dept.1"; 
 YourTable[YourDeptColumn] = "Dept.2";
 YourTable[YourDeptColumn] = "Dept.3"
 );
 "Dept 1+2+3"; 
 "Dept 4"
 )

 YourDeptColumn NewColumn
 Dept.1 Dept 1+2+3
 Dept.2 Dept 1+2+3
 Dept.3 Dept 1+2+3
 Dept.4 Dept 4
 Dept.1 Dept 1+2+3

share|improve this answer

answered Mar 7 at 8:01

StrawberryshrubStrawberryshrub

1,4962517

answered Mar 7 at 8:01

StrawberryshrubStrawberryshrub

1,4962517

answered Mar 7 at 8:01

StrawberryshrubStrawberryshrub

1,4962517