User Profile
Sophie0320
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Maps not working without latitude and longitude
Hello, In the company, my desktop Power BI maps does not show bubbles with country/province/city or post code until I add latitude and longitude. But it works very well on my personal's laptop without lat/long values. According to Tips and Tricks for maps (including Bing Maps integration) - Power BI | Microsoft Learn , I guess my company's Power BI does not send the data in the location bucket to Bing when lat/long values are not provided. The Power BI Desktop version is: 2.97.863.0 64-bit (September, 2021). It does not have the option: File -> Options and Settings -> Options -> Global -> Security and enable: Use Map and Filled Map Visuals. Does anybody know how to turn on this functionality? Thanks SophieA matrix view with a static dimensional column
Hello All, How can I create a matrix like below? The first column is calendar periods with hierarchy. The second column is action types. I would like the second column always visible in the view no matter how I drill up/down on the first period column, like below. Thanks in advance, SophieRe: Report view missing data issue after sorting rows by a custom order
I have not figured our a solution. Let me explain more. Here is the expression of the measure Q1_: Q1_ = var _A = SWITCH (SELECTEDVALUE('Staffing Summary (2)'[Count Type]), "% Completed", DIVIDE(CALCULATE(SUM('Staffing Summary (2)'[Q1_pre]), 'Staffing Summary (2)'[Count Type] = "Staffing Achieved"), CALCULATE(SUM('Staffing Summary (2)'[Q1_pre]), 'Staffing Summary (2)'[Count Type] = "Planned Staffing"), 0), "% Name Identified", DIVIDE(CALCULATE(SUM('Staffing Summary (2)'[Q1_pre]), 'Staffing Summary (2)'[Count Type] = "Names Identified"), CALCULATE(SUM('Staffing Summary (2)'[Q1_pre]), 'Staffing Summary (2)'[Count Type] = "Planned Staffing"), 0), SUMX('Staffing Summary (2)',[Q1_pre]) ) RETURN switch (SELECTEDVALUE('Staffing Summary (2)'[Count Type]), "% Completed", FORMAT(_A,"#%"), "% Name Identified", FORMAT(_A,"#%"),FORMAT(_A, "#,0")) I need to recalculate the two % rows because they cannot simply sum up the value in each Resource Category, like what Q1_pre does. The weird thing is 100% and 50% are gone after I sorted the rows by using the sorted column Count Type (DIM) in the index table. Does anybody know what happened?Report view missing data issue after sorting rows by a custom order
I have a report view like below. The expression of measure Q1_ is on the top, coming from the column Q1_pre. By following Solved: How to sort my rows and columns by cutom order - Microsoft Power BI Community, I created a dimension table to sort the rows. After replacing the column Count Type in the report with Count Type (DIM), the rows are sorted. But two numbers are missing. Anybody know the reason? How can I fix it? Thanks a lot!How to display percentage rows correctly after aggregation
Hello All, I have a table like this: Q1_, Q2_, ..., and Annual Total are measures. The row % Completed was columns added previously in the Query Editor as [Staffing Achieved]/[Planned Staffing]. When I choose all ResourceCetegories, it sums up the values, which is wrong. How to correct it? Same for the last row % Name Identified. Thanks in advance!
