Forum Discussion

EllaJean's avatar
EllaJean
New Member
7 years ago
Solved

Sorting and Autofilling Search

I should start by disclosing that I am a new Power BI user and am still learning its ins and outs.

 

I'm trying to create a "simple" dashboard that allows me to see the frequency in which a product has been flagged due to a problem, what type of problem was the product flagged for and what are the problems with highest flags in a given month. I'm not sure if I'm approaching the best possible way, but I'm having a hard time with the following:

 

  1. For the matrix on the left, I can't seem to be able to sort the data by the month column, only by total. I'd be nice to be able sort by month so I can see the products with the highest number of flags.
  2. Still on that same matrix, when I try to add conditional formating to highlight every monthly count of flags that is >=5, I can't as I don't have the Advanced option in the format tab. Is that because I'm trying to format the count of text?
  3. Is there a way to add some type of visual that allows me enter the product code (first column on the matrix to the left) and then drill down on the data available without updating the rest of the visuals in the dashboard

Hopefully these make sense. Any advice or link to articles that cover these questions is much appreciated. I searched around, but didn't find much that I could implement.

 

Edit: I should have added that my data is organized as product, flag, month. The numbers shown are Count of Flag (not distinct).

 

 

1 Reply