Forum Discussion
Creating dynamic slicer for column month in a table
Thanks for the reply. At present its not working. I am not able to link the supplemental table to the master and "monthly budget table. I think, its a small understanding which I am missing.
My report is using multiple tables from SQL data warehouse. Here are the corresponding tables with respect to your tables and my report structure:
Your Report | My Report tables |
Master | 'Sales order line - data' and 'packing slip line measures" together forms the master table for my report. They are linked through "Sales order line key". The first table has "supplemental part". Second table has "Shippped quantity" and "Ship date" (from a child table - packing slip line) |
Table | "Monthly Budget". 'order' in your table is basically "order budget" in my table |
Date | Date |
Supplemental table | Supplemental table |
I get the following error message when I connect the supplemental table to the other two:
Thanks for help!
Hi Anonymous
I produce your scenario, please check my pbix below.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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!
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: