Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Convert Measures to a table

Hi there,   I have Job_Id and two Measures JobComplete (Precentages) and Margin (Also Presentages) I would like to create a line chart with X-axes as Jobcomplete but you cant put measure as x-axes...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous  ,

    Here is how to create new table:
    Go to MODELLING tab and select NEW TABLE.

     

    The DAX to create new table is like below:

    Table 2 = 
CALCULATETABLE( 
         SUMMARIZE( 'Table1'
                             ,'Table1'[Job_Id] 
                             , "JobComplete" , [JobComplete] 
                              , "Margin" , [Margin]
                              ) )

    Let me know if that helps. If not please share your .pbix file
    Cheers
    Rob

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
7 years ago
Anonymous wrote:

 

I would like to create a line chart with X-axes as Jobcomplete but you cant put measure as x-axes in chart

 

It's true that you can't put measures on the x-axis of a line chart. But if you want to plot two measures against each other a scatter chart might be a better option

 

If you had some simple data like the following:

 

Row Jobcomplete margin
1 50 20
2 50 30
3 60 20
4 60 30

 

A scatter chart would plot this as 4 discrete "dots" which I think is the better approach for plotting two measures against each other.

 

If you tried to draw a line chart from left to right any of the following representations would be valid depending on the order the rows were processed in. There are even more combinations if the line is allowed to double back on itself.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi there,

     

    Thank you for your response, I tired that but the scatter dosen't gives you line between the dots (like excel chart for example) and it very difficult to follow if you have few jobs to display - my wish list is to have a combination between line and scatter chart, but for now I use the other method that Rob suggested. - I need it one measure as X-axes and the oher as a line

     

     

    Thanks,

    Oded Dror