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
PowerBi888
Helper I
Helper I

Accumulate Month

I would like to show 3 data group in 3 Card in same 1 page
Data want to show is Present Month (05) Amt=50, Month April (04) Amt=40 and Month accumulate Jan to March = 10 +20 +30 = 60
How to show 3 data in same one page report:
Year   Month Amt
2019   01      10
2019   02      20
2019   03      30
2019   04      40
2019   05      50

1.Month May show 50 ,
2.April show 40 ,

3.Accum Jan-Mar Show 60

Test.png

 

Thank you for all answer.

1 REPLY 1
v-evelk
Microsoft Employee
Microsoft Employee

Hello,

 

I suppose you can use three Table visuals with different filters applied in the "Fields" panel to reach this effect, like in picture below.

 

ThreeTables.PNG

If you want to dynamically change filtration, you can create 3 copies of the same dataset for instance and apply Timeline Slicer for each case.

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Helpful resources

Announcements
Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors