data breakdown by the selected Filters

Atinder — Wed, 09 Feb 2022 14:52:45 GMT

Hello,

I working on a report where I want to see sales breakdown by sub- menu months intsead of the total qty.

Here is my goal I want solid Qty by sales month in the report Like below by slecting month filter.

Sold QTY

JAN: 500
Feb : 500

Re: data breakdown by the selected Filters

Anonymous — Mon, 14 Feb 2022 02:45:57 GMT

Hi @Atinder ,

Do you mean that Sold QTY is not correct currently? Could you please share some sample data from the involved tables on the table visual and the correct result base on some special examples? ls the Sold QTY a aggregation value of fact field or a measure? If it is a measure, could you please provide the related formula? If the "fields" on the visual come from multiple tables, please provide the relationship info if it exist any one. It is better if you can provide a simplified pbix file. Before share some information, please exclude the sensitive info in shared data/file. Thank you.

Best Regards

topic Re: data breakdown by the selected Filters in Developer

data breakdown by the selected Filters

Re: data breakdown by the selected Filters