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 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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

hi, v-juanli-msft 

The month worked, but my year changed to look like the one in the picture

My field is of type number,

if I change the field type to date in edit view

My BI Desktop is in the us,This problem is driving me crazy,Can you imagine why my year is like this

 

Best Regards

alan-li

  • 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 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

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

        Hi Anonymous 

        If [month] is a column, to use it in a measure, please use "MAX", or "SUM" ,,ect, for example

        Measure1=Right(MAX([mONTH COLUMN]),2)

        Best Regards
        Maggie