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
7 years ago

hi v-juanli-msft 

 

Again, it's just a matter of the date

 

Just like in the picture, I have fields in my table but I still get an error

Is there a size limit on the RIGHT function, which is about 12,000 lines in this table

BI hint me not using a function that gets a single result

 

Do you know why

 

Best Regards

alan-li