How to combine two different STACKED HISTOGRAM

[TatianaGuihur]

Hi,  I have to show a bar for the number 1,5 and 7 of ETP_TIT. 

However for the number 2 I need to compare with ETP alloué.  I need to do this in the same graph.    But I only have it in two different graphs because number 2 is different from all the others.  Please Advise. I appreciate your help.

[v-lionel-msft · Accepted solution]

Hi @TatianaGuihur ,

Please refer to my .pbix file.

If it's useless, please provide sample data and expected output.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TatianaGuihur]

Hi @Jihwan_Kim  thanks for your reply.
My numbers 2, 1 5,7 all of them are the column FONDS of the table GRH_POSTE_BUDG_COMP
ETP_TIT is also in the table GRH_POST_BUDG_COMP
ETP_Alloué is in the table GRH_TAB_PARAM
I dont know about Dim Tables but I will read about it.
Any other advise?

[Jihwan_Kim]

Hi, @TatianaGuihur 

If 2,1,5,7 are all in the same column, please try the below logic, or if it is OK with you, please share the sample pbix file, then I can try to have a look into it to come up with a desirable solution.

your measure =

if ( selectedvalue(columnFONDS) = 2, your measure for ETPALLOUE, your measure fore ETPTIT)

Thank you.

Jihwan Kim

If this post helps, then please consider accept it as the solution to help the other members find it more quickly.

[Jihwan_Kim]

Hi, @TatianaGuihur 

Please correct me if I wrongly understood.

I assume that 2 and 1,5,7 are in two different tables.

Is it possible to create one dim-table that contains 1,2,5,7 and create a relationship to each existing table?

Then, you can use the dim table's number for the X-Axis.

Jihwan Kim

If this post helps, then please consider accept it as the solution to help the other members find it more quickly.