Doesn't chart well per month

[Syndicate_Admin]

Hello, good afternoon

I have the following image, on the right is the graph that shows the deviations in percentage by MONTH. on the left are the measurements that calculate the deviations per month. When graphing, I don't get the X-axis with the months (January, February, March, etc).

when I placed Execution month, I thought it was going to be solved, but no!:

How can it be solved?

Adjunto el programa .pbix en google drive: https://drive.google.com/file/d/1HsdFSGnvqgq2sD372iy_KTq8cMjUBwtp/view?usp=sharing

Thank you!.

Best regards.

[Ritaf1983]

Hו @Syndicate_Admin 
Since your file isn't in English, it's quite difficult to decipher. So, I'll explain the concept using my example.
Currently, you don't have an X-axis because you've only added measures that simply appear one after the other.
To display data by month with an X-axis and all its functionalities, you can use a dynamic measure.
For instance, let's say I want to show sales in January, profits in February, and their combined sum in March.
(Of course, there's no real business logic behind this, I'm just demonstrating how to build the functionality of different measures based on months).
In the first step, you should create the months' table that will be disconnected from other tables :

then you can use Dax like :

Dynamic measure example =

var

selectedMonth = SELECTEDVALUE('Disconnected calendar'[Month])

Return

SWITCH(selectedMonth,

1,[Total sales (K/$)],

2,[total profits (K/$)],

3,[total profits (K/$)]+[Total sales (K/$)],BLANK())

Result :

The pbix with the example is attached.
A more detailed guide for the dynamic measure is here:
https://www.youtube.com/watch?v=ODNsd1G4tDM&t=172s

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

[Syndicate_Admin]

Good night! Thank you very much for your help! I was able to do what you said!

But I still have to sort out the months !. It orders me alphabetically, but it does not order me as a date! How can I achieve it?

Google Drive link attached:

https://drive.google.com/file/d/1TYsk5MkDcM-HNz7osmnmE69IVz_PYoeB/view?usp=sharing

Thanks a lot!

Best regards.

[Ritaf1983 · Accepted solution]

Hi @Syndicate_Admin 

The table you created cannot be sorted because it contains a blank row.

This happened because you didn't build it based on a well-structured calendar table, but rather on a fact table. The most correct option is to work with a calendar table. Otherwise, to specifically solve the current problem, you can manually create a months table by typing:

Then you can sort month names by it's number

Resullt :

The updated pbix is attached

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

[Syndicate_Admin]

Thanks a lot! I stay right!

[Ritaf1983]

Happy to help 🙂