dynamic filter of a single table

[jeanbinhozouza]

Hello,  Guys.

I have this table that shows me the billing per month and per company, I need to have a graph that shows the amount billed - shipping costs month by month, in principle an easy task, but I would have to make a measurement and a graph for each client, but The idea is to have a single measure and a single graph, where the dynamic account filter of filtering by company and month could give me some insight into how I should structure the measure, I got stuck at this stage.

[talespin]

@jeanbinhozouza 

Please share source data sample in table form, column names in excel also don't look correct. Please share mock end result you expect.

[jeanbinhozouza]

https://ponsse-my.sharepoint.com/:f:/p/jean_souza/EhoiPZugb4dMqT1dnvmI3AsBU-6gpkJMluc77e7nhoZmNw?e=E... 
@talespin In the link above is the table, I was unable to add it here on the forum

[talespin]

hi @jeanbinhozouza 

I need to know how does your data look like in Table view.

[jeanbinhozouza]

@talespin I attached the data, including the PBI in the folder at the following link: https://ponsse-my.sharepoint.com/:f:/p/jean_souza/EhoiPZugb4dMqT1dnvmI3AsBU-6gpkJMluc77e7nhoZmNw?

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly,

but, if you can change the table's structure in Power Query Editor, please try unpivotting to have a column for company name.

if you cannot change the table's structure, please try using field parameter feature in Power BI.

Unpivot columns - Power Query | Microsoft Learn

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn