Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Goodmorning everyone
I need to build a mixed chart with a bar and a linear representation.
the size of the measures on which I make the calculations are different.
someone would know tell me how to do?
send attached files database in excel, dashboard example of what I did and picture of what I want.
Thank you
Andrea
sorry attachments
Your two tables are not linked with each other.. How you want to show their fields in one chart?
May be this:
Script:
SET LongMonthNames='Gennaio;Febbraio;Marzo;Aprile;Maggio;Giugno;Luglio;Agosto;Settembre;Ottobre;Novembre;Dicembre';
LOAD Month(Serie) as Month,
Vendite
FROM
[esempio.xlsx]
(ooxml, embedded labels, table is Lines);
LOAD Month(Date#(Mese, 'MMMM')) as Month,
Acquisti
FROM
[esempio.xlsx]
(ooxml, embedded labels, table is Istogramma);
I modified the basic dates for the dimension in common (codicemese)
in the bar graph does not show all the months, but only those which have been made both sales and purchases.
Thank you
Andrea
attached example