Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Help with some DAX

I have this measure that is working properly, but now management wants this value (percentage) shown either on a line graph or bar chart for trending and forecast purposes.   This is the measure th...
Need Help
  • Chihiro's avatar
    Chihiro
    7 years ago

    I don't think you need to change anything for the measure, assuming that you have Datetime/Date column in the table.

     

    Create Date Dimension table using either DAX calendar function(s) or using "M" in query editor.

     

    Relate the date columns, making sure Dimension is used as primary.

     

    Plot chart using Dimension date column as axis. Use your calculated measure as value.

     

    Then add either timeline slicer or regular slicer as control.

Chihiro's avatar
Chihiro
Solution Sage
7 years ago

I don't think you need to change anything for the measure, assuming that you have Datetime/Date column in the table.

 

Create Date Dimension table using either DAX calendar function(s) or using "M" in query editor.

 

Relate the date columns, making sure Dimension is used as primary.

 

Plot chart using Dimension date column as axis. Use your calculated measure as value.

 

Then add either timeline slicer or regular slicer as control.