Hello,
I have a list of SAP transactions and I want to show the stock level and a tooltip with a breakdown of what materials they are. On the dashboard I have a silcer with months (for other visualizations). Inventory is the sum of all transactions up to the month marked on the slicer. Unfortunately, as there were no transactions in the month marked on the slicer, the goods are not visible in the tooltip.
In August there was no transaction on material C, and although it is on stock, it is not visible on tooltip.
My destop file is here .
Please give me some suggestions on how I can deal with this.
Thank you.
@maart666 In your Tooltip page, you should have an option for the visual to show items with no values. Or, you need to use ALL or ALLEXCEPT in a measure.
Thank you Greg for answer.
If I turn off filtering on the tooltip visualization I still do not see one with no transaction in selected month:
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
User | Count |
---|---|
101 | |
58 | |
44 | |
28 | |
24 |
User | Count |
---|---|
131 | |
94 | |
76 | |
43 | |
40 |