Forum Discussion

Atinder's avatar
Atinder
Helper III
4 years ago

data breakdown by the selected Filters

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

 

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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