Forum Discussion
Solved
Weekly Sales vs Monthly Forecast in Matrix Visual
Hello, Apologies; I've only recently started learning Power BI, I have tried searching for answers for this issue but perhaps don't know the correct terminology. I'm trying to recreate a repo...
Hi Owen_M ,
There's a feature you can group visuals.
Use grouping in Power BI Desktop - Power BI | Microsoft Docs
It seems unavailable if you want to combine the two visuals into one.
As a workaround, you can show your forecast value in the subtotals using ISINSCOPE function.
You could refer to the article.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Would still be curious if there's a better solution, but, in case any other newbies stumble across this, please note that "over-engineer" was a gross exaggeration, and DAX formulas aren't as scary as they sound; looking forward to continuing learning more about their capabilities!