User Profile
annatan
Helper II
Joined 1 year ago
User Widgets
Contributions
Re: Suggestions for hiding or show tables based on number of selections in a slicer
Thanks for your prompt response. Would it be possible to have "Earlier" and "Later" dynamically display the years selected in the slicer instead? ๐ Then we could just disable the Total Row and Totals Column in the Format pane. That would be perfect!264Views0likes1CommentRe: Suggestions for hiding or show tables based on number of selections in a slicer
Hi Danextian, I copied your measure into my dataset, but I'm not getting the same result. In my case, only the Delta column is displayed, while the other columns are blank. Could you please help me understand what I might be missing? One difference is that my dataset does not have a Date table, since the data is stored at the year level only. I'm not sure if your solution relies on a Date table or any related relationships. Thanks for your help!302Views0likes0CommentsSuggestions for hiding or show tables based on number of selections in a slicer
Hi, I have two overlapping tables in Power BI. The first table displays Condition Rating (%) by year, where the year columns are dynamically driven by a year slicer. The Delta column is actually a separate table/visual positioned beside the first table to show the difference between the two selected years. My goal is to display both tables only when exactly two years are selected in the year slicer. If the user selects one year, more than two years, or no years, I would like the tables to be hidden (or alternatively display a message prompting the user to select exactly two years). What is the best way to achieve this in Power BI? Example: Any suggestions or best practices would be appreciated.391Views3likes12CommentsNew column based on the year selections from a year slicer
Hi, Can I have your help? I have the following matrix in Power BI desktop. And the data was set up Year was from a slicer which has all the year choices from the database, ranging from 2008 - 2030. Now the request is to have one more column which calculates the delta of any two years. The following is expected outcome. ThanksSolved155Views0likes2CommentsRe: Publish reports from app.powerbi.com to SharePoint site
Hi, ibarrau : Thanks for your reply and sorry for the confusion. The picture above shows all my reports which I would like to move from app.powerbi.com to a SharePoint site for now. You are right. I can share straightly from app instead of SharePoint. However, I will have reports from another workspace later on which would be moved from that workspace to the same SharePoint for sharing collaborately. For the picture above, I would like to explain to you that "User Guide", "Capital", "Operational" & "PO" are from 4 different files. When I tried to share with my team SharePoint, I was able to share only one at a time, but I have seen samples which can share all of them at once (just the same setting as in the app). Was it because I have a team site instead of communication site? Do you happen to know? Thanks for your advice.708Views0likes1CommentPublish reports from app.powerbi.com to SharePoint site
Iโm looking for some help moving my Power BI reports from app.powerbi.com to a SharePoint site. Currently, I have multiple Power BI Desktop files published to app.powerbi.com, along with a user guide included in each publish. Iโd now like to share these reports and related documentation through SharePoint. Iโve tried embedding the reports into my SharePoint site but have encountered a few issues: The report only occupies part of the page or the entire page โ I canโt seem to adjust it freely. Iโm wondering if this might be related to the type of site I have (itโs a Team Site, not a Communication Site). I can only embed one report at a time instead of displaying multiple reports together in one section. Could anyone provide guidance or step-by-step instructions on how to best achieve this setup? Thank you in advance for your help! Below are my multiple reports:Solved763Views0likes5Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.