show the share of a particular product from the total figure in Line and clustered column chart

[sukantdas]

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

[v-jiascu-msft]

@sukantdas

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

[sukantdas]

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

[v-jiascu-msft]

@sukantdas

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

[prateekraina]

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 !!!

[sukantdas]

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

[prateekraina]

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 !!!