Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

About creating a complex report

hi all As shown in the attachment, I want to focus multiple charts in one report. Now all I can think of is to use the toolbar to display, but now I need to filter in this chart.So the toolbar part ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    You could create a column first

    date column = RIGHT('Table (2)'[Column1],2)&"/"&"01"&"/"&LEFT('Table (2)'[Column1],4)

    Then use this date column in my formula.

     

     

    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.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

You could create a column first

date column = RIGHT('Table (2)'[Column1],2)&"/"&"01"&"/"&LEFT('Table (2)'[Column1],4)

Then use this date column in my formula.

 

 

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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

hi v-juanli-msft 

That's fine, think very much

 

best regards

alan-li