Forum Discussion
Beginner filtering question
Just create the bar chart putting the “business name” from the table “List of food and grocery companies” in the x-axis and the “expense” (ie the total debit amount) from the table “List of Debits” in the values field.
Hey,
can you place a screenshot from relationships pane that shows all columns of both tables.
Regards
Tom
Hi Tom
Here is the image
The goal is to show a BAR Chart that will have only the list of business that I have in the List of Food and Grocery (Ignore the typo there)
Thank you very much !
Just create the bar chart putting the “business name” from the table “List of food and grocery companies” in the x-axis and the “expense” (ie the total debit amount) from the table “List of Debits” in the values field.
Hi
This is the correct solution, because of the relationship between the tables, this forces the pulling of only the terms that apear in the list of debits.
Thank you
EDH
Hey, please excuse but I misunderstood something ...
Create a Calculated Column in your table "List of Debits" use this code
Is Related = IF(ISBLANK(RELATED('List of Food and Frocery Companies'[Business Name])),"not related", "is related")This flags the companies in the table "List of Debits" that are also available in the "List of Food and Froceries Companies" table.
- Create a slicer from the column "Is Related" and select "is related"
- Add the column Business Name" from the "List of Debits" to the axis of your bar chart
- Add one of the numeric columns to the values field of your bar chart
Done :-)
This will get you started creating Calculated Columns
https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns
Regards
Tom