Forum Discussion

venkataramana's avatar
venkataramana
Regular Visitor
5 years ago
Solved

Need a measure for Line chart in Power BI

Hi, I am creating a line chart in Power BI, with 'month name', 'Company' and 'No of transcations' fields.           1) 'Month name' - it should show all the months for selected year.              ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi venkataramana ,

    I created a sample pbix file(see attachment) for you, please check whether that is what you want.

    % measure = 
VAR _inditrans =
    SUM ( 'Transactions'[No of transactions] )
VAR _permonthtrans =
    CALCULATE (
        SUM ( 'Transactions'[No of transactions] ),
        FILTER (
            ALLSELECTED ( 'Transactions' ),
            'Transactions'[Date] = SELECTEDVALUE ( 'Transactions'[Date] )
        )
    )
RETURN
    DIVIDE ( _inditrans, _permonthtrans, 0 )

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi venkataramana ,

I created a sample pbix file(see attachment) for you, please check whether that is what you want.

% measure = 
VAR _inditrans =
    SUM ( 'Transactions'[No of transactions] )
VAR _permonthtrans =
    CALCULATE (
        SUM ( 'Transactions'[No of transactions] ),
        FILTER (
            ALLSELECTED ( 'Transactions' ),
            'Transactions'[Date] = SELECTEDVALUE ( 'Transactions'[Date] )
        )
    )
RETURN
    DIVIDE ( _inditrans, _permonthtrans, 0 )

Best Regards