Can anyone suggest what am I doing wrong? In my matrix visual the Top 3 show correctly in this order
but as soon as I change it to top 2 it shows
any suggestions help would be appreciated.
Share the download link of the PBI file.
You may download my PBI file from here.
Hope this helps.
@Ashish_Mathur I am looking at it now and works fine but I want to understand what's happening. Your measure "Total" is sum of values in ID column but how does it know to sum it by month?
Since the month field has also been dragged to the visual, the measure considers that as a filter condition.
I cannot understand what tiy want in those columns
Hi @Ashish_Mathur I have two questions...
You can create a 2 columns table with Fruits in column 1 and Categories in column 2. Create a relationship between the tables and now drag Categories to your visual from the new table
I figured it out regarding categories. I see what you mean now. I created the slicer using the calendar table I made. I am having some trouble sorting it so it shows YYYY-MM in sorted order. Below is my slicer and table I use for it
Please read up on "Sort by column" in the Data Model.
How can I create a table whose first column has unique values for fruits and the second column has only two values ("fruits", and "vegetables"). The first column has 14 rows while the second would have only two.
I did this in pivot. I showed top 3 and it showed exactly as in Power BI but I then had to sort based on count id from largest to smallest and then it showed up properly. I have to figure this out now in my Power BI matrix visual.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.