March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi,
I currently have this bar chart:
The orange bar is total company, the green bars are for each department.
It is currently an illusion though, as it is simply two different charts positioned side by side.
Is it possible to create a single chart that displays a total bar as well as individual bars?
Solved! Go to Solution.
yes you can
add to your dimension table a total row. (this way the total will be displayed ).
then in you measure write an swtich statement :
m=
var total = calculate ( [sales amount]) , removefilters( dim[name]))
var current = [sales amount]
return switch(
true () ,
selectedvalue(dim[name] = "Total" total ,
current
)
hope this helps.
Note :
create variables
Hi @Fusilier This is possible to acheive. To show total in clustered bar/column chart follow the steps.
1. First create a table with distinct category, for your case department and add total row with it. You can use union function. For example, I have used region :
All_Region = UNION(DISTINCT('Sales Territory'[Sales Territory Region]), {"All Region"})
2. Create a relationship one to many with the original dimension table. See image below:
3. Create a measure to evaluate Totals for all category and individual category. See example :
Total_Sales_All_Region =
VAR _total = CALCULATE([Total Sales], ALL(All_Region[Sales Territory Region]))
VAR _result =
SWITCH(
TRUE(),
SELECTEDVALUE(All_Region[Sales Territory Region]) = "All Region", _total, [Total Sales]
)
RETURN
_result
4. Now you can create column or bar chart using the newly created column and measure. See Image below:
Hope this helps!!
If, Please accept it as a solution!!
Best Regards,
Shahariar Hafiz
Hi @Fusilier This is possible to acheive. To show total in clustered bar/column chart follow the steps.
1. First create a table with distinct category, for your case department and add total row with it. You can use union function. For example, I have used region :
All_Region = UNION(DISTINCT('Sales Territory'[Sales Territory Region]), {"All Region"})
2. Create a relationship one to many with the original dimension table. See image below:
3. Create a measure to evaluate Totals for all category and individual category. See example :
Total_Sales_All_Region =
VAR _total = CALCULATE([Total Sales], ALL(All_Region[Sales Territory Region]))
VAR _result =
SWITCH(
TRUE(),
SELECTEDVALUE(All_Region[Sales Territory Region]) = "All Region", _total, [Total Sales]
)
RETURN
_result
4. Now you can create column or bar chart using the newly created column and measure. See Image below:
Hope this helps!!
If, Please accept it as a solution!!
Best Regards,
Shahariar Hafiz
yes you can
add to your dimension table a total row. (this way the total will be displayed ).
then in you measure write an swtich statement :
m=
var total = calculate ( [sales amount]) , removefilters( dim[name]))
var current = [sales amount]
return switch(
true () ,
selectedvalue(dim[name] = "Total" total ,
current
)
hope this helps.
Note :
create variables
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |