Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
rajkumarg1991
Frequent Visitor

Microsoft Power BI - Need to trim the line in the graph for Actual income (Current Financial Year)

Dear Mates,

 

I would like to create the actual line in the graph2 which is similar to graph1. Graph1 shows the actaul line as i expected until current month of the Financial year.

 

As we can see the graph2 The actual shows the line until 2024 March. I would like to restrict that line to show untill current month of the finacial year and want to make it dynamic similar to graph2

 

Graph :1 ( Correct or expected)

rajkumarg1991_1-1684334822487.png

 

Graph :2  (Need to Trim/Change)

rajkumarg1991_2-1684334930293.png

 

The Dax measure which i used for calculating Cumulative income for the Graph:2, I mentioned in below.

We need to do filter in the month for limiting curve to show the line until current month of the FY. I'm strugguling to do this, please help me to do solve this issue.

 

actual_income_cummulative =
CALCULATE(
    SUM('analytics commercial_opportunities_graphs_view'[actual_income]),
    FILTER(
        CALCULATETABLE(
            SUMMARIZE(
                'Date Opportunity',
                'Date Opportunity'[Date Order],
                'Date Opportunity'[Date 2]
            ),
            ALLSELECTED('Date Opportunity')
        ),
        ISONORAFTER(
            'Date Opportunity'[Date Order], MAX('Date Opportunity'[Date Order]), DESC,
            'Date Opportunity'[Date 2], MAX('Date Opportunity'[Date 2]), DESC
        )
    )
)
 
Note: the above calculation is done using quick measures. Which is already available in power bi.
Thanks in advance.
1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

For dates that you don't want the actual value to render your measure needs to return BLANK()

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

For dates that you don't want the actual value to render your measure needs to return BLANK()

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors