Forum Discussion
Continous X Axis with data (integers) from two different tables
Hello there, me again,
Solved my last problem with continuous X-axis involving dates from two different table with the CALENDARAUTO() functionnality (thanks again to jthomson) but I'm now having the same issue with a similar X-axis with interger values instead of dates. Is there a CALENDARAUTO()-like functionnality working with columns containing integers ?
Have you got some magic tricks in your hat to help me with that problem ?
Hi GregoryMartin,
Filtering out the blanks could be helpful.
Result = FILTER ( DISTINCT ( UNION ( VALUES ( Table1[ID] ), VALUES ( Table2[ID] ) ) ), [ID] <> BLANK () )Best Regards,
Dale
5 Replies
jthomsonSolution Sage
You can probably try something similar using the GENERATESERIES function, if you are able to work out the highest and lowest values of your two tables (or know what sort of values you expect them to be), you can plug these in and it'll make a table of integers that you can relate your data to and use the value column as a common link for your axis
v-jiascu-msftMicrosoft Employee
Hi GregoryMartin,
If you have the integers in different tables, you can bring them together in a new table like this.
Result = DISTINCT ( UNION ( VALUES ( Table1[ID] ), VALUES ( Table2[ID] ) ) )
Best Regards,
Dale
Before all, thank you both for your quick answers.
jthomson : I juste can't found the function you told me about. Power BI only give me the choice between GENERATE and GENERATEALL (as seen on th screenshot). GENERATESERIES is a function given with a plug-in ?
v-jiascu-msftI'd already tried to do this way but I couldn't create the relation between this new table and the two others, due tu a non unique values column.- v-jiascu-msft
Hi GregoryMartin,
Filtering out the blanks could be helpful.
Result = FILTER ( DISTINCT ( UNION ( VALUES ( Table1[ID] ), VALUES ( Table2[ID] ) ) ), [ID] <> BLANK () )Best Regards,
Dale
