@johankent30 share sample data from tables you currently have and explain what you want. Read this post to get your answer quickly.
@parry2k I've tried to include more info, but let me know if you need anything else. I have the following visual.
You can see that I am analyzing the AP data by a date heiarchy. The table that feeds this visual looks like this.
What I am hoping to do is to create a date slicer that can filter just the subcategory of "Purchase Orders". So referring back to the first pic attached, the purchase orders amount is $1399 for each day, but I want to be able to select dates from a slicer list and choose which days the purchase orders show up in the visual. So if I selected 9/1/2019 then purchase orders would have $1399 on 9/1/2019 and 0 on all of the other days, but the Payables line would not change. The measure that I believe needs to be changed is in the second pic. I would think there would be a way to filter the Date Value column in the table illustrated above for only the dates selected in a disconnected date table, and for this to only apply if the row had "Purchase Orders" as the subcategory, but I can't seem to figure out the solution. Thanks!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.