Error con tooltips personalizados en power bi service
I'm reaching out for help to report an issue I've been experiencing for quite some time. When I configure a visual with a custom tooltip and publish it to the Power BI service, when I hover the cursor over the polygons (in an Icon Map), the tooltip appears and disappears instantly. This problem persists even when drilling down into a specific polygon. I should also mention that this issue occurs both in the Power BI service itself and when exporting the report to a public web link. Below is a 20-second GIF illustrating the problem. Note: It works perfectly in Power BI Desktop; the problem only occurs on the web. I hope you can help me with this.
Drill down on Matrix no longer an option after marking date dim table as date table
I have a matrix that I created that used a date dim table date field as one of the values. I wanted to add some previous months calculations to the matrix. In order for my dax to work properly, I marked the date dim table as a date table. Now however, The date field from the date dim table no longer shows a time hierarchy (year-> quarter -> month). it only has stagnant dates (1/1/2023). If you use the date field from the date dim table in a visual, does marking the date dim table as a date table prohibit the drill down feature? After marking the date dim table as a date, I now have this icon next to the field. Has anyone found a way to mark the date dim table as a date table, but still be able to use it in visuals that will allow the drill down feature?
Visualization Not working as needed with dax measure
Visualization drill down not showing. I can only drill through the non-compliant data and not the compliant ones. I have created a formula to check how much data is compliant and non-compliant. For example, if the customer has all the fields populated then he is compliant, so their details are missing from the Query1 table. If the member has a missing information, then he is non-compliant and will be available in the query table. Compliant Formula = DISTINCTCOUNT('DW v_Member'[MemberNum])/CALCULATE(DISTINCTCOUNT(Query1[MemberNum]),ALL(Query1)) Non-Compliant= 1- ( DISTINCTCOUNT('DW v_Member'[MemberNum])/CALCULATE(DISTINCTCOUNT(Query1[MemberNum]),ALL(Query1))) I have also created a calculated column in the member table to check if I can showcase both compliance and Non-compliance data but that is also not working Compliance Check = IF( COUNTROWS( FILTER( Query1, Query1[MemberNum] = 'DW v_Member'[MemberNum] ) ) > 0, "Non Compliant", "Compliant" ) Table information : Dw_Member: is a fact table with all customer information Branch is a fact table with all of company branches Date table Query 1 comprises of only those customers whose profile has a missing information for example date of birth or address etc. A customer can appear more than once if they have multiple information missing Donut chart appears correctly with compliant and non-compliant measures but all other measures are not getting drilled through see second chart
Calculating cumulative values with drillable dates
Hello 🙂 I would like to visualize transaction data in a bar and line chart. I want to show the cumulative total on the line and the transaction by period in the bars. I would like to be able to drill up and down. Model The relevant sections of my model are set up like this: Measures / DAX Used Total Completed Transactions = COUNT( Transactions[Transaction ID] ) Total Transactions = CALCULATE( [Total Completed Transactions], USERELATIONSHIP( TRANS_DateTable[TRANS_Dates], TRANS_Events[Initial Transaction Date] )) Total Successful Transactions = ([Total Transactions] - 'Totals Measures'[Total Cancelled] - 'Totals Measures'[Total Returned] - 'Totals Measures'[Total Defective]) Cumulative Total Transactions = CALCULATE('Totals Measures'[Total Transactions], USERELATIONSHIP( TRANS_DateTable[TRANS_Dates],TRANS_Events[Initial Transaction Date] ), TRANS_Events[Initial Transaction Date] <= MAX(TRANS_Events[Initial Transaction Date])) I have tried two methods to get my desired results. I should also note that my cumulative measure did use the FILTER and ALLSELECTED formulas at one point, but there was no difference in the results, so I removed it). Method 1: Fields: Shared Axis: TRANS_Dates Column Values: Total Transactions Line values: Cumulative Total Transactions Chart results: In table format: Issue with Method 1: The cumulative value does not calculate/display correctly. Method 2: Fields: Shared Axis: Initial Transaction Date Column Values: Total Transactions Line values: Cumulative Total Transactions Chart Results: In table format: Issue with Method 2: Cannot drill up or down. Desired results: A table and bar and line chart that displays totals for distinct periods as well as the cumulative total for that period. I also want to be able to slice by TRANS_Date and drill up and down for a range of viewpoints, like below (with contrived data): Year over Year perspective: Month over Month perspective: Week over week (end of week) perspective: Any help you could offer would be greatly appreciated! Thank you!
Last week today - last year drill down to day results
Hei, I hope you can help me. I need to create a measure that brings data per day for Last week - last year. So far I've managed to bring data per week with this measure: LWTD LY := VAR CurrentWeek = MAX(Time[WeekNr]) VAR CurrentYear = MAX (Time[Year]) VAR PriorYear = IF(CurrentWeek =1, CurrentYear-1, CurrentYear) VAR PriorWeek = IF(CurrentWeek=1, CALCULATE( MAX(Time[WeekNr]),ALL(Time), Time[Year]=PriorYear),CurrentWeek-1) RETURN CALCULATE([Sales],ALL(Time), Time[Year]=PriorYear, Time[WeekNr]=PriorWeek) This gives me the following results where the totals of the week sums are correct. However what I need is to bring data per date, not only the total of the week. How can I achieve this?Drill down and bookmark
Say I have population data in 2015 and 2020 of all the countries in the world. Now I build my bar chart which compares population in 2020 Vs Population in 2015. Since I want to do dive in more info , I created hierarchy such that continent, country and then cities are 3 levels. If user click drill down and select one contienent, it drilled to all countries in that continent and compare population of 2020 Vs 2015 in these countries. Similarly if a user click any country, it drilled down to all cities in this country and compare the population of 2015 vs 2020. So Continent ---> Country ---> Cities are 3 levels Now until now is pretty standard, what I want that if a user wants to go next level say from continent to country, a new set of visual or table displays. Similarly if user click to drill down to next level of cities, the old visuals hides and new set of visual displays. How can I do this ?? Please help as I totally stuck here and I am pretty new to PBI with no one arround me who has expertise in this area
