general
26 TopicsStacked Column Chart Data Limit Issue
I am encountering an issue with a stacked column chart in Power BI. Even though my data source only contains 200 rows, I'm still seeing the "i" icon (indicating a data limit issue). My x-axis shows phases, and my y-axis represents indexes (used as the legend to create the stack). I need the columns to be stacked as they currently are, but I'm unsure why this error is occurring with such a small dataset and how to resolve it.Solved13KViews4likes7CommentsArchitecture Patterns for Healthcare Data Platforms on Fabric
Architecture patterns for healthcare data platforms include building unified data foundations in Microsoft Fabric, where unified data is foundational to scaling AI effectively and Microsoft Fabric simplifies the analytics stack and accelerates time to value. What to include: Bronze → Silver → Gold Lakehouse layers Medallion architecture for clinical data Security boundary using Fabric Workspaces186Views0likes1CommentHealthcare Semantic Model
Hello all, I have been having some difficulty trying make the most efficient semantic model I can for my report. I'm finding a classic star schema to be challanging due to the content of my data. I'll do my best to summarize the organization of the data, in hope it can generate some ideas. General list of tables: Person_MRN (MRN as PK and Person_ID as FK) Person (Person_id as PK and wider table about the person) Condition_occurrence (features Person_ID, Visit_occurrence_id, diagnosis vist info) procedure_occurrence (features Person_ID, Visit_occurrence_id, procedural vist info) visit_occurrence (visit_occurrence_id as PK and care_site_id as FK) care_site (Care_site_id as PK) The design of my report is just to identify the distinct count of MRN with a filter selected condition and/or procedure, and the care site breakdown of those meeting the filter requirments. I am asking to map MRN -> condition_occurrence.person_id -> visit_occurrence.visit_occurrence_id -> Care_site.care_site_name but I also need MRN -> procedure_occurrence.person_id -> visit_occurrence.visit_occurrence_id -> Care_site.care_site_name since patients have more than one condition and/or procedure, I have to map through the visit_occurrence_ID's in order to capture the unique visits. There could even be a case where a distinct MRN with a distinct procedure was seen at more than one care site. I tried to make views to coalesce the information, but I haven't found the perfect fit yet. Any thoughts are appreciated!Solved19KViews3likes3CommentsIdea: Box and Whisker or Violin Plot Visuals as Standard Visuals
While there are third-party visualizations for Box and Whisker or Violin Plot visuals, some organizations don't allow the installation of third-party sources. Box and Whiskey or Violin Plot are very useful for understanding the mean, upper/lower quartile, and the max/min values of a dataset. Example might be HEDIS quality performance, BMI, paid per procedure -- all to better understand clinical variation in the community and within medical service centers. Box and whisker plots are frequently used visualizations in academic literature.9.1KViews3likes3CommentsShow whole year while slicing on one month - DAX
Hello, I am trying to get whole year for a diagram when using the filter "month year". For example when using the filter 202201 I want the whole 2022 to result in values for my diagram. How can I do that? I have one date table "Calendar" and I have one Sale table "DimSale". Greatful for all help!6.6KViews0likes3CommentsMicrosoft Fabric Known Issues
Known issues are temporary bugs that we've discovered in Microsoft Fabric. These bugs are known and are being actively fixed. Before you submit a Support request, or search Community forums for an answer, see if the problem that you're experiencing is already known to Microsoft. There are two locations to look up current known issues: Known issues as a list on Learn Known issues page on the Fabric support site To create a support ticket, visit https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket. For service level outages or degradation notifications, check https://support.fabric.microsoft.com/.5.7KViews2likes0CommentsGetting FHIR Data on Browser version of PowerBI
Hi I've started working on the browser version of Power BI, as I have a Mac, and can't really set up a Windows image just yet. I'm trying to connect to a FHIR data server but can't find the 'Other' option that is quite easily visible in the Desktop version shown in videos. Currently, I have set up a Workspace and selected 'Add -> GetData'. I get an option to 'Add New Item' but when I click on it, I can't see any option to search for a FHIR data type and connect to a FHIR server. Attaching a screenshot. Will appreciate help and guidance on this please. Thanks6.4KViews1like5CommentsGetting Error while running the paginated report in report builder
The 'Hidden' expression for the grouping 'DayOfMonth' refers to the field 'Date_Day_Of_Month'. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case. ---------------------------- The definition of the report '' is invalid. ---------------------------- An error occurred during local report processing.Solved1.4KViews0likes1Comment