Forum Discussion

bowz1977's avatar
bowz1977
New Member
3 years ago
Solved

How To Remove Empty Quarter From Chart Chart

I have a measure setup to calculate the Margin % that i've charted out, the data does not start until 6/2021.   How do I get the chart to start at 6/1 (Q2) vs. Q1 so I don't have Q1 showing up with...
Need Help
  • DataInsights's avatar
    DataInsights
    3 years ago

    bowz1977,

     

    Try rewriting the measure like this:

     

    Margin % =
DIVIDE (
    SUM ( 'TABLE'[ExtendedSell] ) - SUM ( 'TABLE'[ExtendedCost] ),
    SUM ( 'TABLE'[ExtendedSell] )
)

     

    Hardcoding "1" in the measure prevents the suppression of blank if the DIVIDE expression returns blank.

     

    A more performant version of this measure uses a variable:

     

    Margin % =
VAR vExtendedSell =
    SUM ( 'TABLE'[ExtendedSell] )
VAR vResult =
    DIVIDE ( vExtendedSell - SUM ( 'TABLE'[ExtendedCost] ), vExtendedSell )
RETURN
    vResult

     

DataInsights's avatar
DataInsights
Super User
3 years ago

bowz1977,

 

Try rewriting the measure like this:

 

Margin % =
DIVIDE (
    SUM ( 'TABLE'[ExtendedSell] ) - SUM ( 'TABLE'[ExtendedCost] ),
    SUM ( 'TABLE'[ExtendedSell] )
)

 

Hardcoding "1" in the measure prevents the suppression of blank if the DIVIDE expression returns blank.

 

A more performant version of this measure uses a variable:

 

Margin % =
VAR vExtendedSell =
    SUM ( 'TABLE'[ExtendedSell] )
VAR vResult =
    DIVIDE ( vExtendedSell - SUM ( 'TABLE'[ExtendedCost] ), vExtendedSell )
RETURN
    vResult

 

  • bowz1977's avatar
    bowz1977
    New Member
    3 years ago

    Thanks for the quick help! Worked!