I want to create a pareto diagram in Power BI. But every time i change the filters the diagram gets distorted. Let me explain – I have a column named indicator-where i have name of indicators which can repeat. In the second column i have the dates-which shows on what date corresponding indicator has been captured. I want to create a pareto which will which indicator is contributing most to the total. I tried the RANK function, but still after changing date filter in the slicer, everything goes disturbed. I used Pareto by Sio2graph (https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200001423?tab=overview), and it worked for all my filters. But due to its limited customization, i can not use it. But yeah, if someone could help me write a general and robust dax for pareto just like by sio2graph. that will be helpful.

I have a Power BI matrix visual and want to disable the drill down and drill up features (i.e, not the drill thru features). I went to Options and turned off the option for Stepped Layout. I also turned off the drill down and drill up features on the visual formatting tab (i.e, I turned off the ‘Drill on dropdown’, the ‘Drill up’, the ‘Show next level’, and the ‘Expand to next level’ features). After turning all these to off I published the dashboard to the service, but the drill down and drill up features are not disabled. Any ideas why?

I need help with a Device status chart.. I am exporting the status of some devices every hour to a table. I want to track them via some sort of graph.. doesn’t have to be the same as the example below but anything that will show the same thing in some way would be great.

I Have a column named new year which extracts fiscal year from a given date column. The problem is that this new year column have whole number data type and when I converted it into date data type then the dates inside the new year column changed.

I want to get the value of “Beg of year” column for 2015 from the column “Open at the end” and Year 2014, same as shown in below snapshot

Closed 2 days ago.

I have 3 tables:

Schedule refresh option is not working/Hide/Disabled in Power Bi Service

I’m working on creating a Power BI report where users can input a specific date to drive the metrics displayed in the report. I’m exploring options to achieve this and need some guidance.

I’m working on creating a Power BI report where users can input a specific date to drive the metrics displayed in the report. I’m exploring options to achieve this and need some guidance.