Forum Discussion
Need Help - How to Filter Rows in a Matrix Visual While Retaining Sparklines in Power BI?
I have a matrix visual in Power BI with Product Category and Subcategory in the rows. The values include Profit Margin and sparklines that display the Margin at the monthly level. I want to allow us...
Create a Measure:
Filtered Margin =
IF(
[Profit Margin] > SelectedValue('FilterTable'[Margin Threshold]),
[Profit Margin],
BLANK()
)
Use the Filtered Margin measure in the "Values" field of the matrix.
Ensure sparklines are still based on the unfiltered data (original %Margin measure) so they don't disappear.
💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn