Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

How to Show Only Grand Totals in a Bar Chart

Hello All,

 

 

I'm Facing a problem in only showing the sum of these column in a bar chart. 

 

I tried ding it as this way but I don't think its the best Idea or best practice to do it.

 

 

Capture.PNG

 

as you can see in the picture, I tried adding all column to the values box and summing them all.

 

and as I said before, I don't feel its a good way to do it 

 

please if anyone has any alternative way to do it, don't hesitate to share it with me.

 

 

thank you all in advance.

1 ACCEPTED SOLUTION
negi007
Community Champion
Community Champion

@Anonymous 

You can create a measure like below

=calculate(sum(values),entry type="issue")

 

let me know if it works for you or not.




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

View solution in original post

1 REPLY 1
negi007
Community Champion
Community Champion

@Anonymous 

You can create a measure like below

=calculate(sum(values),entry type="issue")

 

let me know if it works for you or not.




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.