Unable to display month result only

[Chris932]

Hi!

I need help with displaying the month's data only like the 1 shown below. Like for Jan 2022, it is shown as a dot only.

I have another chart but it is not showing a straight line(dark blue) which is the summarization for the entire year 2022.

Thanking you in advance for any assistance rendered.

Chris

[v-rongtiep-msft]

Hi @Chris932 ,

Could you tell me which field or measure is applied to the Values field? If it is a measure, could your please provide the formula.

Does the above visual come from two or more tables? If so, did you create a proper relationship between the two tables?

If, as in my case, the data for 2021 and 2022 are in different tables，create a relationship between the two tables in terms of months

Please refer to it to see if it helps you.

Create relationships between the two tables.

If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Chris932 , You can create measure of jan

calculate([Measure], Date[Month]= "Jan")

or

calculate([Measure], Filter(all(Date), Date[Month]= "Jan"))