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.
basically this should be easy.
Without knowing the exact structure of your table I would recommend the following:
1. Create Slicer with the category from your expenses table
2. Create a bar chart and use the name of the company from the company table on axis and the expenses colum as value
3. select the food category in your slicer
Done!
Maybe you will get a company called (blank) on the axis, this indicates that there companie in your expenses table,that are not in your company table.
Hope this gives you an idea
Regards
Tom
Hi Tom
I am a beginner
I see the slicer, but can you explain what do you mean when you say "with the category from your expenses table"
Which category should that be ?
Thank you
EDH
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.