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?Problem creating a clustered column chart to count tickets
Hi I'm still new to power bi and I have an issue creating a clustered column chart with 2 columns on the x-axis. I want to create a clustered column chart that counts the number of tickets created and resolved per month. I have a data set that contains a ticket reference number, the creation date and resolution date. When I add the creation date and resolution date to the X-axis only one column of data is displayed. I have tried switching off the concatenate option on the x-axis. Creation date and resolution date are both formatted as date type.: date thanksVisualising a process flow
Hi there. I'm new to PowerBI and trying to visualise (graphs and tables) the performance of a process over time, eg the trends by week of how much "value" moves through about six steps of a process from identifying a potential sale through the selling then delivering then billing. The data I have is in two tables: a sales table with the dates that each unique sales opportunity moves from step one to step two etc, and the value is the monthly recurring revenue that it will be once delivered. The second table (delivery table) breaks the sales order into a number of services, that each then have a delivery date and a "first billed" date. The output I'm hoping to build is for example: This week, $20k worth of value was identified ie entered the first step of the process, $50k moved from step 1 to step 2, $30k moved from step 2 to step 3 etc. And therefore at the end of the week, $200k was sitting in the WIP bucket that had moved from step one to step two, but hasn't yet moved to step three. What's the best way to visualise this, and what do I need to do to my data tables for it to work, including beinf able to filter by product, by sales person etc? Thanks for your help.
One Column, Many Variables - how to create a scatterplot
Hi All My data has as all variables (eg. revenue, costs, profit) in one column called Variables. In another column, I have all the data called Data. In another column, I have the respective company names, called Company_Names. I wish to create a scatterplot graph, Revenue on x-axis and Costs on y-axis, with Company_names show per data point. How can I create this? Thank you
Pareto Chart.. almost there just missing something
Hi All, I am very close to achieving a successful pareto chart however i am missing something and it is causing a problem for me. Here is my data: What I am trying to achieve is a pareto chart to show the duration hours vs the room number. The DAX for TotalAmount = SUM(ENGINEER_TABLE[DURATION_HOURS]) The DAX for Cumulative Percent = [DURATION_HOURS] / [TotalAmount]. Here is the graph at the minute: As you can see it is calculating the percentage total correctly... however why is it not to 100 percent at the right hand side? Please help, Thanks!
