How to create a stacked bar containing top 5 sales and others?
Hi All, I'm new to Power BI. I have a stacked graph like this below, The visual shows the total sales across different countries and the cities acts like stacks. My requirement is to regroup this stack into two categories - Top 5 city sales as one group, and the rest as a separate group. Example- US consists of cities like NY, LA and many others. I need to group the top 5 cities in the US such as NY, LA and 3 other cities in one group, the other cities that do not fall in the top 5 should be in a separate group named "Others" (Like the below chart). The report should show data for all the countries like this. I have attached the link to the PBIX for your reference. Thanks to you in advance! PBIX file link - Download PBIX file here With regards, Shriram
Fill Blanks with latest if based on sequence
Hello there, I'm having some trouble on solving this one. To give a breif example, we have a sequence from 1 - 5 each with a status and date. Sometimes the user skips this sequence and now I'd like to fill the gap with the latest date available. Example ID Status StatusID LatestDate 025755 Intial Lead 1 Jan 1 2021 025755 Regular Lead 2 Jan 5 2021 025755 Hot Lead 3 To be filled 025755 Signature Pending 4 To be filled 025755 Success 5 Jan 25 2021 Example2 ID Status StatusID LatestDate 025755 Intial Lead 1 Jan 1 2021 025755 Regular Lead 2 To be filled 025755 Hot Lead 3 14 Jan 2021 025755 Signature Pending 4 025755 Success 5 Now as you can see we have 2 statuses in example 1 that were skipped and thus have no dates. My objective is to fill these blank spaces for each group(ID) with the latest date available based on the max status/statusID. In example 2, 1 status was skipped and the latest current Id is 3, so we only need to fill the one in between. By default, status(ID) 1 always has a date. Thanks!
Calculated column type mismatching in MS List automatic report
Dear All, When I use "Integrate --> Power BI" feature in MS List web App, the type of a calculated column of the report, don't match the ones of the columns used in the formula. I've shared this problem with the MS List community, but they have confirmed it and don't have a solution. They have suggested me to talk about this issue in the Power BI community. Is There someone can help me? Thanks for your Help
