Forum Discussion
How to combine two different STACKED HISTOGRAM
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.
Hi TatianaGuihur ,
Please refer to my .pbix file.
If it's useless, please provide sample data and expected output.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
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.
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?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.
Hi TatianaGuihur ,
Please refer to my .pbix file.
If it's useless, please provide sample data and expected output.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
