Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
Hello Everyone,
I have an issue with dates calculations :
I try to evaluate a stock at different dates. To do so I have two files : one with the stock evaluated today and another one with the required quantities and the dates corresponding.
To decide the date at which I want to see the state of the stock, I use a slicer "before" with all the dates from a date table.
However, when I do not have any requirements before the date selected, the line is completely removed from my matrix (which I don't want, I would rather have the stock as it is now).
How can I force Power BI to display the line even if there are no data?
Here is when I have a requirement within the period selected , but if I go 10 days before, the line doesn't appear anymore.
I also give you the measures that I use :
Solved! Go to Solution.
@Anonymous +0 or show item with no data , may help to show data
Stock reel - BOM = CALCULATE(SUMX('Stock usine','Stock usine'[Stock usine] - [Pack requirements **bleep** - BOM]), FILTER('Bill of Materials','Bill of Materials'[(BOM) Base Component]), FILTER(ALL(DateTable),DateTable[Date] <= MAX(DateTable[Date])))+0
Pack requirements **bleep** - BOM = CALCULATE(SUMX('Packaging needs','Packaging needs'[Requirement Quantity (ERFME)]),FILTER(ALL(DateTable),DateTable[Date] <= MAX(DateTable[Date])), FILTER('Bill of Materials','Bill of Materials'[(BOM) Base Component])) +0
@Anonymous +0 or show item with no data , may help to show data
Stock reel - BOM = CALCULATE(SUMX('Stock usine','Stock usine'[Stock usine] - [Pack requirements **bleep** - BOM]), FILTER('Bill of Materials','Bill of Materials'[(BOM) Base Component]), FILTER(ALL(DateTable),DateTable[Date] <= MAX(DateTable[Date])))+0
Pack requirements **bleep** - BOM = CALCULATE(SUMX('Packaging needs','Packaging needs'[Requirement Quantity (ERFME)]),FILTER(ALL(DateTable),DateTable[Date] <= MAX(DateTable[Date])), FILTER('Bill of Materials','Bill of Materials'[(BOM) Base Component])) +0
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
86 | |
71 | |
68 | |
50 | |
30 |
User | Count |
---|---|
119 | |
101 | |
73 | |
65 | |
40 |