topic Re: dynamic filter of a single table in DAX Commands and Tips

dynamic filter of a single table

jeanbinhozouza — Thu, 29 Feb 2024 15:39:15 GMT

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.

Re: dynamic filter of a single table

Jihwan_Kim — Fri, 01 Mar 2024 03:15:49 GMT

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

Re: dynamic filter of a single table

talespin — Fri, 01 Mar 2024 10:10:50 GMT

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.

Re: dynamic filter of a single table

jeanbinhozouza — Fri, 01 Mar 2024 11:38:06 GMT

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

Re: dynamic filter of a single table

talespin — Fri, 01 Mar 2024 12:38:56 GMT

hi jeanbinhozouza

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

Re: dynamic filter of a single table

jeanbinhozouza — Fri, 01 Mar 2024 14:53:57 GMT

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?