Forum Discussion
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:
- 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.
- 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?
- 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).
Hi EllaJean ,
For your first issue, you could refer to below link about the rank:
https://community.powerbi.com/t5/Desktop/Matrix-Column-Head-Order/td-p/71572
Fro your second issue, the conditional formating could work with the measure, I suggest you create a measure to show different formatting with "Rules" :
For your third issue, I am afraid you could not achieve any visual for you to drillthrough in dashboard, it could just work in report:
https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough
Regards,
Daniel He
1 Reply
- v-danhe-msftMicrosoft Employee
Hi EllaJean ,
For your first issue, you could refer to below link about the rank:
https://community.powerbi.com/t5/Desktop/Matrix-Column-Head-Order/td-p/71572
Fro your second issue, the conditional formating could work with the measure, I suggest you create a measure to show different formatting with "Rules" :
For your third issue, I am afraid you could not achieve any visual for you to drillthrough in dashboard, it could just work in report:
https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough
Regards,
Daniel He