Forum Discussion

New Member

8 years ago

Solved

Beginner filtering question

Hi I have a long excell with credit card expenses that I downloaded from my bank for example Company Date expense XXXX 01.01.18 $200 WWW 02.01.18 ...

PaulDBrown
8 years ago
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.

New Member

8 years ago

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 !

Super User

8 years ago

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

Regards

Tom