Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi PowerBI Experts,
Please find the below image. Here I am showing two two bars. I have a field called type, where I have e.g. 5 types. a,b,c,d,e.
The below two bars are showing two different values for all types. And the red dot which is the line value shows the calculation based on type 'a' only. Now the user wants to show the share of type 'a' in the two below bars.
Now the bars are showing the total values of all types, like a+b+c+d+e. And the user wants to she the below chart with the share of only type 'a' in two bars.
Looking for a helping hand.
Thanks a ton in advance.
SKD
Hi SKD,
@prateekraina’s method works well. The measure may be this one:
Value Of A = CALCULATE ( SUM ( 'Table1'[Value] ), FILTER ( 'Table1', 'Table1'[Type] = "a" ) )
You can have a look at the picture below. If your data looked like this, you also can try it.
Best Regards!
Dale
Hi Dale & Prateek,
I am using Line & Clustered Column Chart. As I have to show two different figures for each year, with one value as line value. So, will this method work here as well.And you have done the calculation for one column from on table. But in my case we have two different columns from two different tables. So, what will be the DAX for that. And the thing is that I had already tried to use the Column Series here as well as the object which you have used in your example, but that particular option is disable for me. Not sure how to add the Type over there. Need your more guidance on it.
Thanks & Regards,
SKD
Hi,
The measure would be the one shows the result you want. We can't create it without source data. Could you post a sample here please? The Column Series should be a column. Could you post a picture about how the option is disabled.
Best Regards!
Dale
Hi @sukantdas,
I am not able to understand your problem statement.
If you simply want to show Type A then just filter the chart on that value.
Kindly elaborate your requirement if thats not what you intend.
Thanks !!!
Hi Prateek,
I can't filter it out to Type 'A'. Because if I will filter it out to type A, then the chart won't show the total figure , which its currently showing. The user wants the bars to show the total amount(for both the bars) what it is showing now, as well as the values of Type 'A'(in both the bars).
In short the current chart will remain as it is, we need to show another figure in that chart i.e. for Type 'A'.
Thanks
SKD
Hi @sukantdas,
In order to do that, you need to create a measure which will calculate total across bars and then you can put that measure in tooltips.
It will solve your problem.
Thanks !!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |