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
szielinski
Frequent Visitor

Sum after a Year Chart Cumulative

hello im want to know if is possible get soem values summarized after certain time for example i want to know the qty of sites after 2022 all this in the chart 

szielinski_0-1633468716195.png

like in here instead of put any value after year 2022 shows the count of everything after that

1 ACCEPTED SOLUTION
TheoC
Super User
Super User

Hi @szielinski 

 

You can do a couple of things. One quick way is to create a Calculated Column like below:

TheoC_0-1633473527755.png

 

Then in the Fields pane (far right of screen), click the "Year" column and the "..." button. Go to "New Group" then in Group Type change "Bin" to "List".  From the list, select the historical and current year (i.e. 2019 to 2021) and use the "Other" group to include "ungrouped values". Click Okay.

TheoC_1-1633474708257.png

You can now use the "Year (groups)" field for your X axis.

TheoC_2-1633474813713.png

Hope this helps 🙂

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

View solution in original post

1 REPLY 1
TheoC
Super User
Super User

Hi @szielinski 

 

You can do a couple of things. One quick way is to create a Calculated Column like below:

TheoC_0-1633473527755.png

 

Then in the Fields pane (far right of screen), click the "Year" column and the "..." button. Go to "New Group" then in Group Type change "Bin" to "List".  From the list, select the historical and current year (i.e. 2019 to 2021) and use the "Other" group to include "ungrouped values". Click Okay.

TheoC_1-1633474708257.png

You can now use the "Year (groups)" field for your X axis.

TheoC_2-1633474813713.png

Hope this helps 🙂

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

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.