Can't see all the months in a graph

[Abevann]

Guys, I guess is a simple question,

I did a graph time vs amount and seems fine when I have values for all months:

Nevertheless once I filter a specific person,  the graph doesn't display all months, only the ones that have any value:

This way looks very confusing, because it seems that sales go fine all the year, but the thing is that fabruary, march, may, june and october are not in the graph. So I would like to see continous time even more if there is no value in the same way than the first graph. How to do so?

I already tried Show elements with no data, but made it worse: 

It unfilter everything and shows all the months in the stored data, time filter doesn't work anymore, so didn't help.

Thanks a lot!

[Anonymous]

Hi @Abevann ,

As @AlexisOlson suggested, you can create a date dimension table (if you don't have one), put the date field of that date dimension table on the X axis of your visual. Then see if you can get what you want.

If the above setup does not give you the results you are looking for, can you please provide the following information.
1. How did you set your visual? Could you please share the setup of the Fields panel and some sample data for those fields referenced by your visual. Are these fields all from the same fact table? If not, please provide the corresponding relationship information.

2. Please provide its formula if there is any measure

3. What is the data type of the field placed on the X-axis of your visual? 

Best Regards

[Abevann]

Hi @Anonymous,

1. Here is the bar graph setup:

2. Here are the formulas, and all fields are from the same table (admDocumentos):

Doc vent sin canc MXN y USD = [Doc vent sin canc MXN en USD] + [Doc vent sin canc en USD]

Doc vent sin canc MXN en USD = DIVIDE([Doc vent sin canc en MXN], AVERAGE(admDocumentos[Tipo de cambio diario]), 0)

Doc vent sin canc en MXN = SUM(admDocumentos[Doc vent en MXN]) - [Doc canc vent en MXN]

Doc vent sin canc en USD = SUM(admDocumentos[Doc vent en USD]) - [Doc canc vent en USD]

Doc canc vent en USD = (CALCULATE(SUM(admDocumentos[Doc vent en USD]), FILTER(admDocumentos, admDocumentos[CCANCELADO] = 1)))

Doc canc vent en MXN = (CALCULATE(SUM(admDocumentos[Doc vent en MXN]), FILTER(admDocumentos, admDocumentos[CCANCELADO] = 1)))

Sample:

Fecha	Doc vent sin canc MXN y USD	Doc vent sin canc MXN en USD	Doc vent sin canc en USD	Doc vent sin canc en MXN	Doc vent en USD	Doc vent en MXN	Doc canc vent en USD	Doc canc vent en MXN
04/01/2021 00:00	$285.80	$285.80	$0.00	$5,690.00	$0.00	$5,690.00
14/04/2021 00:00	$1,021.09	$1,021.09	$0.00	$20,496.90	$0.00	$20,496.90
28/07/2021 00:00	$3,944.00	$0.00	$3,944.00	$0.00	$3,944.00	$0.00
21/09/2021 00:00	$757.50	$0.00	$757.50	$0.00	$757.50	$0.00

3. On axis is date (from date table), and I'm looking for monthly and yearly resolution

Thanks a lot, regards,

Abelardo

[AlexisOlson]

Are you using a calendar date dimension table for your x-axis?

Is your x-axis Type set to categorical or continuous?

[Abevann]

I look for this configuration but there is no such an option (type) on the menu:

 

[Abevann]

Hi @AlexisOlson,k

Sorry I missed the first question, I have a date dimension table:

Correction; I change the date field to date table:

Nevertheless now there is no hierarchy and the information is splited by day; I tested both continous and categorical,