Forum Discussion

Jonathas's avatar
Jonathas
Frequent Visitor
6 years ago

To stop the amount stock by

Dear, i'm breaking my head with this problem, i need to stop of to calculate the balance stock at today using mouth/year because a have lot of data to use amount by day, in summary, my model is as fo...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Jonathas 

Do you use "campo_data" and "ano", " mes ano" columns in the X-axis field of the line chart?

Could you show a screenshot of the columns/measures added into the line chart?

 

Best Regards
Maggie
 
Jonathas's avatar
Jonathas
Frequent Visitor
6 years ago

Hi v-juanli-msft  firtly i'de like to thank by reply



I'm using the mes ano in the X-axis field, i created with the option New group, 

The field content is : (are at brazilian format day/month/year)
data_sk campo_data ano mes mes_ano

1 02/01/10 2010 1 "janeiro de 2010"

.
.

.
9125 26/12/34 2034 12 "dezembro de 2034"

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Jonathas 

    First we should know the correct way to use date hierarcy.

    Then you can click on the icons to expand all level or axpand from year level to month level.

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.