Visualisation (Slicer and Button Slicer)
Hi everyone, I hope you all have a nice day. I want to ask (pictures attached), I gave an example of me using visualisation of "Button Slicer (Top)" and "Slicer (Bottom)" in the picture, I have a table where I have Reporting Date column then I make custom column for the quarters and months. The "Year" in the slicer is from Reporting Date hieararchy (Year), but the quarter and month in the slicer, they both are custom column that I made from the Reporting Date column (so they are not the hieararchy of "Reporting Date"). My questions (I don't mind if you answer with "Slicer" visualisation or "Button Slicer" visualisation): In Picture 1, If I select Q1 and it turns grey, how do the visualisation slicer for months turns black (for Jan, Feb, Mar) without me selecting the Quarter slicer? In Picture 2, If I select any month (for example: Aug) and it turns black, how do the visualisation slicer for quarter turns grey (Q2) without me selecting the Quarter slicer? In Picture 3, If I select Year "2025" and it turns black, how do the visualisation slicer for quarter and months also turns black without me selecting Quarter and Month slicer? Please kindly help me answer my questions. Thank you in advance. God bless. 😊🙏
Disable uncertified custom visualisations with intune
Hi there, I hope this is the right place to ask this. Instead of using Azure AD Group Policy, our organisation uses Microsoft Intune. Therefore, the documentation on how to disable uncertified Power BI custom visualisations doesn't apply: Does anybody know how to apply this same rule in Microsoft Intune? I'm unable to find any resources online that seem to point me in the right direction. Thanks in advance! KrisProductivity Visual from Excel in PowerBI
Hello everyone, I'm new to PowerBI. I've completed the DIAD course and watched a few videos on youtube. I'm fluent in Tableau but am working on transitioning my reporting into PowerBI. I've never built anything like this in either program and was curious if you could help me build this in PowerBI. I know I can use a matrix to display employee name, day, and values similar to the first 8 columns, but that's as far as I can go. Can I create a column in Power Query or something for the Objective column? Or should I create a reference table with employee name and objective to connect to and add the Objective column after values? Hours absent is a column that requires the manager to manually enter data. Can this be done in PowerBI? My thought was to offer a dropdown for values 0 - 40. In Tableau, I'd use a parameter but I'm not sure how to do this in PowerBI. Total Tasks is just the sum of daily values. Objective - Absence is the Objective minus (Hours Absent * Objective/40). The final column is the total tasks / objective - absence. Should I create a new measure or new column for these calculations? Lastly, is it possible to format the matrix in a similar fashion?
Visualizations intermittently fail to load
Hi, We're experiencing an issue with PowerBI Report Server (Jan 19). In particular one report, where, if I save the report from PBI Desktop to the report server, and then open up the report from report server, the report loads fine. However, if opening the report up after a scheduled refresh, some of the visualizations will fail to load. If I allow the visualizations to error, and then CTRL+F5 then they tend to load ok the second time, but this is not acceptable for our users obviously. I'm presuming it's some sort of timeout, but it'll be different visualizations failing each time. The data is being queried from a few SharePoint (on prem) lists. The scheduled refresh itself, doesn't take long to run. I don't really want to extend the timeout as it already takes 20 seconds or before the visuals fail, shouldn't have to wait that long for a dashboard to load. We have other dashboards that have more data in that load fine. One other thought is that this dashboard has a scheduled refresh for every 10 minutes, whereas our other dashboards refresh hourly. Could this have an impact? Thanks
