Forum Discussion

Saxon202202's avatar
Saxon202202
Icon for Helper III rankHelper III
3 years ago

Measure not display in chart

I have the following two columns are in direct query Date&Time and Time2. I created new measue based on the Date&time column for Time1.  Time1 = FORMAT(CALCULATE(MAX('TIME'[Date&Time])),"HH:MM:SS")...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
3 years ago

Hi Saxon202202,

 

Since you are formatting the measures has text you cannot used them in a bar chart or any ohhter type except tables. 

 

 

To have this working on a chart you need to use the formatting trough a calculation item. 

 

If you want I can setup an example and share with you. 

  • Saxon202202's avatar
    Saxon202202
    Icon for Helper III rankHelper III
    3 years ago

    MFelix , Thanks for your reply. Yes, please help me and explain the steps and share the PBI file. 
    just let you know the source of data is direct query and came SQL.
    I am trying to change the datatype by using convert function with data type "Date and Time" but still same result.

    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      3 years ago

      Hi Saxon202202 ,

       

      Unfortunalty the calculation groups do not work in Direct Query mode so this option is not available for your case, even so if you are interested I can send you a wakltrough.

      • Saxon202202's avatar
        Saxon202202
        Icon for Helper III rankHelper III
        3 years ago

        MFelix , Thanks for your reply again. Yes, I am interested can you please share the information step by step so it will help to understand. 
        Question: Direct query will be support to create a new calculated column?