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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

hi, v-juanli-msft 

think very much

Now I have a problem again. I want to create a new measurement value of ATA_MONTH. This field is in my excel data, but BI tells me that I do not have it when I create the measurement value

Then I want the data of ata_month to be turned into English instead of Numbers in the report. Do you know how to solve these two problems

 

 

Best Regards

alan-li

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

Hi Anonymous 

You could create a measure

Measure = FORMAT(MAX('Table'[date]),"yyyy-mmmm")

Or a column

Column = FORMAT('Table'[date],"yyyy-mmmm")

See reference for "FORMAT"

https://docs.microsoft.com/en-us/dax/format-function-dax

 

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.