Forum Discussion
Applying a filter in Power BI
Super Userjstar1234554321 You can always create dummy data to explain the problem, without data sometimes it is hard to interpret. Not asking for real data.
This is a link to some very basic dummy data which I copied and pasted multiple times. Effectively in my dashboard, I have a list of KPIs on top one of which is the budget from the first sheet. The second is a change in value of the option (column B vs column H). and then a range of bar charts etc. At the bottom, I have a table which has used a sumif function to calculate the current value whilst also taking the budget from the budget tab. I wat to include a dropdown which will basically allow me to also filter the budget data based on category.
Did my dummy data come through as a link?
Book
This is my dummy data. The KPIs link per category. I want to find a way to link the filter to the category and the budget.I can go into more detail if required.
