data breakdown by the selected Filters

[Atinder]

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

[Anonymous]

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