Adding a “Team Avg” in a line and stacked column chart? PBI Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Data science time! April 2019 and salary with experience The Ask Question Wizard is Live!Power BI Filter by MeasureMeasure to sum another aggregated measure's dataDAX Calculate Average when all categories are presentMeasure that averages District Office and Total Company sales per weekpowerBI: use measure value as a filter to a unrelated datasetDAX - Creating a measure in power BI which ignores all filters except onePower BI Visual use one side of date slicerHow to make a Line and Stacked Column Chart in Power BI NOT filter when slicing into smaller date range?Power BI DAX calculated column to find alternatives from a different tableDisplaying Aged Debt over two financial years - Function 'IF' scalar expressions have to be Aggregation functions over CurrentGroup()
Converting a text document with special format to Pandas DataFrame
How to break 信じようとしていただけかも知れない into separate parts?
How to make an animal which can only breed for a certain number of generations?
What could prevent concentrated local exploration?
Does using the Inspiration rules for character defects encourage My Guy Syndrome?
Recursive calls to a function - why is the address of the parameter passed to it lowering with each call?
Does traveling In The United States require a passport or can I use my green card if not a US citizen?
What is the definining line between a helicopter and a drone a person can ride in?
Can this water damage be explained by lack of gutters and grading issues?
When does Bran Stark remember Jamie pushing him?
Can a Wizard take the Magic Initiate feat and select spells from the Wizard list?
Why did Israel vote against lifting the American embargo on Cuba?
Why are two-digit numbers in Jonathan Swift's "Gulliver's Travels" (1726) written in "German style"?
Is there a verb for listening stealthily?
/bin/ls sorts differently than just ls
A journey... into the MIND
How was Lagrange appointed professor of mathematics so early?
Raising a bilingual kid. When should we introduce the majority language?
Putting Ant-Man on house arrest
Will I be more secure with my own router behind my ISP's router?
Protagonist's race is hidden - should I reveal it?
Coin Game with infinite paradox
Does the Pact of the Blade warlock feature allow me to customize the properties of the pact weapon I create?
Has a Nobel Peace laureate ever been accused of war crimes?
Adding a “Team Avg” in a line and stacked column chart? PBI
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
Data science time! April 2019 and salary with experience
The Ask Question Wizard is Live!Power BI Filter by MeasureMeasure to sum another aggregated measure's dataDAX Calculate Average when all categories are presentMeasure that averages District Office and Total Company sales per weekpowerBI: use measure value as a filter to a unrelated datasetDAX - Creating a measure in power BI which ignores all filters except onePower BI Visual use one side of date slicerHow to make a Line and Stacked Column Chart in Power BI NOT filter when slicing into smaller date range?Power BI DAX calculated column to find alternatives from a different tableDisplaying Aged Debt over two financial years - Function 'IF' scalar expressions have to be Aggregation functions over CurrentGroup()
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I have a chart that shows 4 values for me(picture in the end):
Stacked Column: Non-Billable Hours and Billable Hours
Lines: Billable Ult % and Total Ult %
And I have a Chiclet Slicer that allows me to select which of my employee I want to check the chart.
What I need now is to add the avg for the whole team, either as an "employee" that I can select in the slicer or with lines for Billable Ult % and Total Ult % but that would need to be displayed independently of who you selected in the slicer. If I create the measures to calculate the team avg is it possible to do it? If not I will proceed to create another graphic for the whole team and use buttons to present it.
Chart Sample
powerbi dax powerbi-desktop
asked Mar 22 at 13:53
Georges VicentinGeorges Vicentin
34
add a comment |
I have a chart that shows 4 values for me(picture in the end):
Stacked Column: Non-Billable Hours and Billable Hours
Lines: Billable Ult % and Total Ult %
And I have a Chiclet Slicer that allows me to select which of my employee I want to check the chart.
What I need now is to add the avg for the whole team, either as an "employee" that I can select in the slicer or with lines for Billable Ult % and Total Ult % but that would need to be displayed independently of who you selected in the slicer. If I create the measures to calculate the team avg is it possible to do it? If not I will proceed to create another graphic for the whole team and use buttons to present it.
Chart Sample
powerbi dax powerbi-desktop
asked Mar 22 at 13:53
Georges VicentinGeorges Vicentin
34
add a comment |
I have a chart that shows 4 values for me(picture in the end):
Stacked Column: Non-Billable Hours and Billable Hours
Lines: Billable Ult % and Total Ult %
And I have a Chiclet Slicer that allows me to select which of my employee I want to check the chart.
What I need now is to add the avg for the whole team, either as an "employee" that I can select in the slicer or with lines for Billable Ult % and Total Ult % but that would need to be displayed independently of who you selected in the slicer. If I create the measures to calculate the team avg is it possible to do it? If not I will proceed to create another graphic for the whole team and use buttons to present it.
Chart Sample
powerbi dax powerbi-desktop
asked Mar 22 at 13:53
Georges VicentinGeorges Vicentin
34
I have a chart that shows 4 values for me(picture in the end):
Stacked Column: Non-Billable Hours and Billable Hours
Lines: Billable Ult % and Total Ult %
And I have a Chiclet Slicer that allows me to select which of my employee I want to check the chart.
What I need now is to add the avg for the whole team, either as an "employee" that I can select in the slicer or with lines for Billable Ult % and Total Ult % but that would need to be displayed independently of who you selected in the slicer. If I create the measures to calculate the team avg is it possible to do it? If not I will proceed to create another graphic for the whole team and use buttons to present it.
Chart Sample
powerbi dax powerbi-desktop
powerbi dax powerbi-desktop
asked Mar 22 at 13:53
Georges VicentinGeorges Vicentin
34
asked Mar 22 at 13:53
Georges VicentinGeorges Vicentin
34
asked Mar 22 at 13:53
Georges VicentinGeorges Vicentin
34
asked Mar 22 at 13:53
Georges VicentinGeorges Vicentin
34
asked Mar 22 at 13:53
Georges VicentinGeorges Vicentin
34
34
add a comment |
add a comment |
0
active
oldest
votes
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
);
);
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
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55301132%2fadding-a-team-avg-in-a-line-and-stacked-column-chart-pbi%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55301132%2fadding-a-team-avg-in-a-line-and-stacked-column-chart-pbi%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
