cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills 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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors