Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Creating dynamic slicer for column month in a table

Further building this report table. https://community.powerbi.com/t5/Power-Query/linking-to-master-table-to-match-fields-and-summarize/m-p/1017854#M34625   I need to create a slicer for month for ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

thanks for response. 

My mistake. I forgot to mention that the order budget are unique amount budgeted for each month., so they should not be summarized. Here is the excel version of it.

 

What changes should I make to the 5 measures under "Monthly budget" table so that they "don,t summarize".

 

 

 

 Thanks for help!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Like to add to my previous reply. 

At present the 5 coloumns are showing some random continous number 37, 38,39,40. MTD is blank as there was no shipment in april.

According to me , the problem is from "supplemental part#" in the first column below. The supplemental part here is from table "Sale order line' becase all the details which follow after that is from the same table. However, "sale order line' table and "monthly budget" is connected through the bridge table. I am unable to understand why its showing random numbers for supplemental part from "sales order line" table.

 

When I use the supplemental part from "Monthly Budget" table then, it shows the correct details. However, the other details goes wrong in that scenario. Please see below: