Required two measure’s value across an axis in Line Chart based on slicer

Question

Dear All,I am new and infant to power bi and facing lot of challanges for moving Tableau reports to Power BIAnd below is the sample data format which is in my oracle dbCompany Q2 FY 2018&nbsp; Q3 FY 2018&nbsp; Q4 FY 2018&nbsp;&nbsp;Q1 FY 2019&nbsp; Q2 FY 2019&nbsp; Q3 FY 2019X&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0Y&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp;Z&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp;All&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp;I had line chart which is desinged in tableau with 2 lines one is orange color line which is for company A and other is Blue color line which is for X,Y,Z&nbsp;I had created a power bi report where I am able to show only one line in a legend whcih is applied for All,X,Y,Z companieswhen I select any value in slicer.But my requirment is what ever company I select in slicer it should display in line chart along with company A as shown in above tableau line charthttp://www.mediafire.com/folder/jn1hiwrqhm6gt/LineChartCan any one please help me in solving this issue ,For refrence you can download the file from above line

v-piga-msft · Answer

Hi&nbsp;infantpowerbi&nbsp;,
For your requirement, please try this measure below.
All =
CALCULATE (
    SUM ( 'Table2'[Value] ),
    FILTER ( ALL ( Table2[District] ), 'Table2'[District] = "ALL" )
)

Here is the ouptut.

More details, please refer to the attachment.
Best&nbsp; Regards,
Cherry
&nbsp;

infantpowerbi · Answer

Tq very much you are my galidator&nbsp;:smileyvery-happy: ,I lost hope on this

infantpowerbi · Answer

Hello,&nbsp;In my case it'snot working ,Requeest you to please kindly please review my pbix file and please let me know what's the issueand where I am missing to get the things donehttp://www.mediafire.com/folder/ifj41f0t3w30g/2_lines_in_Line_charts&nbsp;

v-piga-msft · Answer

Hi&nbsp;infantpowerbi&nbsp;,
From your sample, I found that your error is casued by the dax highlighed below.
&nbsp;
All =
CALCULATE (
    SUM ( 'Ratifications_Table'[District Short] ),
    FILTER (
        ALL ( Ratifications_Table[District Short] ),
        'Ratifications_Table'[District Short] = "ALL"
    )
)

As your&nbsp;Ratifications_Table[District Short] column is a string type, so it cannot be usefd with sum function so you will have error message.
I'm afraid that you should create the measure like below.
All_ =
CALCULATE (
    SUM ( 'Ratifications_Table'[Value] ),
    FILTER (
        ALLSELECTED ( Ratifications_Table ),
        'Ratifications_Table'[District Short] = "ALL Districts"
    )
)
&nbsp;
Best&nbsp; Regards,
Cherry

infantpowerbi · Answer

Does Sum can be only applied for decimal numbers ?Because I a trying to make it for % columns ,But finding no luck.Kindly please look into % column "AppSubmission"&nbsp;https://www.mediafire.com/folder/rfypu8b8p5pe7/

Forum Discussion

Required two measure’s value across an axis in Line Chart based on slicer

5 Replies

Related content

Fabric & Azure Data User Group Program Requirements & Benefits

Help required to write DAX measure

Measure required in Power BI matrix

Slicer requirement

Filter required for Multiple measures for combo chart