Forum Discussion

GregoryMartin's avatar
GregoryMartin
Frequent Visitor
8 years ago
Solved

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 ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi GregoryMartin,

     

    Filtering out the blanks could be helpful.

    Result =
FILTER (
    DISTINCT ( UNION ( VALUES ( Table1[ID] ), VALUES ( Table2[ID] ) ) ),
    [ID] <> BLANK ()
)

    Best Regards,

    Dale

jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
8 years ago

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