Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Below is the sample data i have:
I have two date parameters which the user will select dynamically. Let say they select 2024-07-01 and 2024-10-30. i would need the values summarized for the months selected July-Oct in this case
and eventually summarized
Solved! Go to Solution.
If your data that your bringing in actually looks like the sample above you will need to first pivot the data.
Go to Transform Data select your table
Then we are going to pivot the data so that the months are all in one column not in different columns.
(if you actually have a column with a date rather then a month the would be better because you could use the slicer to filter by date otherwise you can only do it by month as your header, but that could cause and issue if you are looking at past years or once you reach the next year) but for our example it would be the same process.
Your data would look now something like this, I would rename Attribute to Month then Close and Apply.
Insert a Matrix table and add your values as shown below. Then you can just add a month slicer which you can select different months at the same time. (Again if you have a date rather then a month that would allow you to do what you need above and instead of months you would select the months in between).
If your data that your bringing in actually looks like the sample above you will need to first pivot the data.
Go to Transform Data select your table
Then we are going to pivot the data so that the months are all in one column not in different columns.
(if you actually have a column with a date rather then a month the would be better because you could use the slicer to filter by date otherwise you can only do it by month as your header, but that could cause and issue if you are looking at past years or once you reach the next year) but for our example it would be the same process.
Your data would look now something like this, I would rename Attribute to Month then Close and Apply.
Insert a Matrix table and add your values as shown below. Then you can just add a month slicer which you can select different months at the same time. (Again if you have a date rather then a month that would allow you to do what you need above and instead of months you would select the months in between).
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |