User Profile
giramswa
Helper II
Joined 4 years ago
User Widgets
Contributions
How to show no data (0%) in gauge until slicer is selected
What measure do I need to create to show no data in my gauge visual until I select something from my slicer? I have 'Budget' in my value shown as percentage, and in my slicer I can select the Project Number. When I have not selected anything in the slicer, it's just combining all the data from all Projects and show in guage and I do not want this. I don't want to hide the gauge visual instead I want it to show empty (0%) when there is no selction in slicer. How to do this?Replace Data source of report from SQL Server to Live Power BI dataset
I have a tricky situation. Ex-colleague originally published a report with an independent dataset by importing the tables from SQL Server. After building other reports with similar data requirements, I developed a central dataset that can be shared across all of these reports. My issue is that I would like to publish a new version of the standalone report with one using the central dataset-including the report GUID, subscriptions, etc. Basically, I do not want my users to know anything changed, have to update bookmarks, etc. Currently, when I try to change Source (Transform Data >> Data source settings >> Data sources in current file), I only see original SQL Server and when I click on 'Change Source...' button, the only option is SQL Server dabase. I would like to change source to Power BI dataset published to service which has same table structure. Is this possible?
