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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.