I have a Power BI report and I ve created 2 calculation Groups in Tabular Editor
The first one holds my measures such as Act Sales, Target, LY Sales, LY-1 Sales, % vs. Target etc called "Metrics" and the second calculation group holds the MTD, QTD, YTD etc called "Time Intelligence".
In my report I have a table with columns the Metrics Calculation Group (and I have a slicer to let viewer choose what they want to see) and the columns are also dynamic with the use of field parameters. I have also one slicer with the Time Intelligence so they see all the measure in the Period they chose (MTD, QTD, YTD etc).
But I want to offer a cleaner view and make the blanks and zeros disappear from my table. If the Act Sales are 0 or blank I want this row not showing (lets say that in the rows we have products). So, if one products Act Sales are 0 this product I don't want to appearing in the table.
How can I make it work?
Thank you in advance!