Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I would like to filter the FCST Version and see only data for that particular time frame. Currently the matrix is showing all Month/Year's and just populating "Forecast" values for the filter selected (see Jun-22 through Aug-22). I only want to see where both "Forecast" and "Current Orders" are both populated.
I know this may be a relationship issue...Here are my relationships for reference.
Thank you
Solved! Go to Solution.
Hi mngma0102,
Consider putting Current Orders is not blank and Forecast is not blank in the filter pane for your matrix visual.
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.
Hi mngma0102,
Consider putting Current Orders is not blank and Forecast is not blank in the filter pane for your matrix visual.
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
103 | |
101 | |
87 | |
73 | |
67 |
User | Count |
---|---|
119 | |
111 | |
95 | |
79 | |
72 |