Power BI - Filter and Drill Breadcrumb Bar
Users can often get lost in drilling and the application of filters on a page, and currently the only way to restore the page is to use the green refresh arrow to revert any changes made. It would be beneficial if there was a breadcrumb type of capability that showed all the steps applied and allowed the user to reverse a step (or more) and get back to a previous state.
AD users password changing causing scheduled refresh fails
Hi, My clients use my Power BI Report Server and setup their domain account on Data sources page in order to retrieve data from shared drives. Once they change their password, the data refresh will fail to work. Do we have any means of Power BI Report Server user settings synchronisation with AD? Thank you
Changing Data through slicer
I would like to create new data based on a slicer setting i have chosen linked to a parameter values. For example, i have a baseline monthly forecast for 2022. I would like to apply a percentage change to this baseline forecast for alternative scenarios. For instance, i want to see what the forecast looks like if it was 5% higher than the baseline forecast. I need this at the data column level and not a measure so that i can create some formulas off that new column data. For instance, if column B is the baseline forecast, I have create a new column that equals the baseline forecast column multiplied by (1+ parameter value); in this case, i set my slicer to 5%. I could have easily chosen 6% or something else, that's the type of functionality I'd like to build. I have created a measure that works visually for this, but i realized I really need this at the column level to use it for other things the way I want. Adjusted Forecast = 'sheet1'[Baseline Forecast]*(1+'Adjustment Parameter'[Adjustment Parameter Value]/100)
DAX Largest Change from Previous month HELP
Hi team, I'm trying to create a visual that shows the top 5 variables in a specific column that experienced the largest change since the previous month. So as we add data on a monthly basis, I would like to show the largest 'movers' each time we refresh the data (on a monthly basis). The variables are string values. My inputs are the following measures I've created: Current Month = CALCULATE((COUNTROWS( 'CLIENT DATASET'))) Previous month Count CALCULATE( COUNTROWS('CLIENT DATASET') , PREVIOUSMONTH('CLIENT DATASET'[Time of Breach])) Difference = [Current Month] - [Previous month Count] When I apply the final Measure (Difference) to the variable in the table I want to analyse the monthly change (a column with string values, not numbers, but thats where i presume the [Current Month] measure comes in) and create a table visual out of it, I get the exact same output if I were to create a table visual with the variable against count per variable. Please help in informing me how im going about this problem in the wrong manner. cheersRelative Change
I'm trying to create a table which shows the top N entities that experienced the largest amount of change relative to the previous month (actual quantities or percentage change, doesnt matter). I have tried the following DAX query but it doesnt work because one of the columns carries string types. Measure = sum('CLIENT DATASET'[Model Breach])-CALCULATE(SUM('CLIENT DATASET'[Model Breach]),PARALLELPERIOD('CLIENT DATASET'[Time of Breach].[Date],-1,MONTH)) Any other way I can create something like this?
Getting the difference of a value between two seperate time slicers.
Hey Everyone, I'm trying to figure out a measure to give me what the difference between two time slicers are. We're trying to find out how many events has happened in the current date, the previous date and get a measure to determine what the movement between has been. I've seperated the Dates into two sheets form the samesource, one will be my "Comparison Month" and the other "Current Month" The formulas are as follows, and both of them give me the correct answer. Comparison Month= calculate([Count Total Instances],filter('Workforce','Workforce'[Start Date ]= max('Start Date Comparison'[Start Date ]))) Current Month = calculate([Count Total Instances],FILTER('Workforce','Workforce '[Start Date ]=max('Workforce'[Start Date (bins)]))) Problem occurs when I want to make the measure to subtract Current from the Comparison. I use the formua Movement = [Current Month] - {Comparison Month] However, for some reason it appears that the comparison is = 0, as this formula just returns to Current Month E.g. Current Month= 10 Comparison Month = 8 Movement=10 (when it should be 2) Thank you!
Change between tabs automatically using java script
Hello people, I have this to change between power bi reports each 5 minutes, using javascript on a html page, this is for visualization purpose only: <html> <head> <script language=JavaScript> window.onload = hora; function recargar() { location.href=location.href } function hora(){ var fecha = new Date(); var minuto=fecha.getMinutes(); if (minuto % 2 == 0) { /*1*/ document.getElementById('EseMismo').src="https://app.powerbi.com/view?r=eyJrI..."; } else { /*2*/ document.getElementById('EseMismo').src="https://app.powerbi.com/view?r=eyJrI..."; } } setInterval('recargar()',300000); </script> <title>Global data</title> </head> <body style="background-color:rgb(235,234,232);"> <table> <tr> <td width="1800" height="650"> <div> <iframe id="EseMismo" width="100%" height="100%" src="https://app.powerbi.com/view?r=eyJrIjo..." frameborder="0" allowFullScreen="false"> </iframe> </div> </td> </tr> </table> </div> </body> </html> ¿Can I change between tabs on a power bi report instead on power bi reports? Thanks
