User Profile
cgrimes
Advocate II
Joined 7 years ago
User Widgets
Contributions
automatic rotating visual carousel for tooltips
It would be great if tooltips could have more content without having to take up more screen space. One way to do this is to allow the creation of a tooltip carousel, where a tooltip would cycle through a list of tooltip report pages, allowing the creation of multiple data insights.Visual filtering interaction is causing errors
When I select an item from the table, all visuals fail. same an all tabs, report was functioning normally yesterday Feedback Type: Frown (Error) Timestamp: 2022-01-05T15:43:17.9371156Z Local Time: 2022-01-05T10:43:17.9371156-05:00 Session ID: 465d9882-9521-4a1d-89ea-0deb83b60be0 Release: December 2021 Product Version: 2.100.785.0 (21.12) (x64) OS Version: Microsoft Windows NT 10.0.19044.0 (x64 en-US) CLR Version: 4.7 or later [Release Number = 528372] Peak Virtual Memory: 57.5 GB Private Memory: 2.62 GB Peak Working Set: 2.28 GB IE Version: 11.789.19041.0 User ID: 5c410b3b-6aaf-4bb7-a748-8aaa7d40f489 Workbook Package Info: 1* - en-US, Query Groups: 1, fastCombine: Disabled, runBackgroundAnalysis: False. Telemetry Enabled: True Model Default Mode: Import Model Version: PowerBI_V3 Enabled Preview Features: PBI_shapeMapVisualEnabled PBI_azureMapVisual PBI_enableWebView2 PBI_sparklines Disabled Preview Features: PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_dataPointLassoSelect PBI_compositeModelsOverAS PBI_dynamicParameters PBI_enhancedTooltips PQ_WebView2Connector PBI_useModernFormatPane PBI_scorecardVisual Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 100% Supported Services: Power BIRe: Can't get filters to work properly for Snapshot Customer life cycle table
I found a solution! The challenge was that when I charted the "data orders" against the date axis, it filtered the customers based on the order date! So I needed to get a filtered list of all customers regardless of the date. I changed my measure to do just that: # Lost Customers = var custlist = CALCULATETABLE(SUMMARIZE('Data Orders',[Customer_Number-Seq]),ALL('Date Master')) Return CALCULATE ( COUNTROWS( CustomerEvents ), KEEPFILTERS(CustomerEvents[Event] = "Lost" ), TREATAS(custlist,CustomerEvents[Customer_Number-Seq]) )*-1 adding the summarized 'Data Orders" table for the unique customer IDs that included ALL dates did the trick. I then used TREATAS to provide the relationship I was looking for. Now filters and slicers work as expected.
