Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
Apologies for the newbie question I am new to PowerBI.
Example of what I am trying to achieve:
Example Data set (Dates not shown in visual):
|Site ID|Site Name|Food Category|Sales|Date|
|1|Test Site 1|1|$40|June 23|
|1|Test Site 1|2|$50|June 23|
|1|Test Site 1|1|$50|May 23|
|1|Test Site 1|2|$60|May 23|
|2|Test Site 2|1|$100|June 23|
|2|Test Site 2|2|$200|June 23|
|2|Test Site 2|1|$100|May 23|
|2|Test Site 2|2|$50|May 23|
When filtered by "May 23" & "June 23" it would combine all the "Sales" for the same "Food Category"
|Site ID|Site Name|Food Category|Sales|
|1|Test Site 1|1|$90|
|1|Test Site 1|2|$110|
|2|Test Site 2|1|$200|
|2|Test Site 2|2|$150|
When unselecting "May 23" will only show "June 23" and vise versa and when unselecting every date range it will show all combined.
I hope this makes sense.
Thank you
Solved! Go to Solution.
Hi @rnanban
What you describe is how the default behaviour should work.
If you have a table visual in your report that contains Site ID, Site Name, Food Category and Sales (NOT the Date)
And a filter or slicer on the page that contains the Date, then by interacting with the slicer/filter you should get the behavior that you are looking for.
Note that you would need to make sure that the Sales column has the right data type (number/currency, NOT text for example)
Let me know if it is still not working as intended. 🙂
Best regards,
Daniel
Proud to be a Super User! | |
Hi @rnanban
What you describe is how the default behaviour should work.
If you have a table visual in your report that contains Site ID, Site Name, Food Category and Sales (NOT the Date)
And a filter or slicer on the page that contains the Date, then by interacting with the slicer/filter you should get the behavior that you are looking for.
Note that you would need to make sure that the Sales column has the right data type (number/currency, NOT text for example)
Let me know if it is still not working as intended. 🙂
Best regards,
Daniel
Proud to be a Super User! | |
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
69 | |
68 | |
40 | |
29 | |
26 |
User | Count |
---|---|
89 | |
49 | |
44 | |
38 | |
37 |