User Profile
Mjolnir
Helper I
Joined 2 years ago
User Widgets
Contributions
Allow PowerBI users to display reports in dark or light mode / theme
I have created various reports with a dark color theme as I prefer this as well as many other users. For some users, lighter themes and modes seem to be more appealing and it would be great if Power BI had a built in toggle function to switch between dark and light mode for users. When changing between both modes, you should be able to disable its interaction with certain report content - for example preventing bars in a chart from changing colors as you toggle between dark and light mode.Enable custom drill down order rather than the order set by the rows / columns
Example: A matrix with sales data, with the following row dimensions: region, business area, product category and customer. Currently in Power BI this allows you to drill down on sales by the same order the dimensions are sorted in the matrix's rows. Though it would be very powerful if you could choose to drill down on any order you desire and by any dimension you select. For instance, 1) right click "total sales" 2) hoover on "drill down by..." 3) choose the desired dimension, "... customer" 4) if you want to drill down further from sales by customer, then repeat step 2) and 3) and choose to drill down on sales by customer by any other dimension available.Re: Rolling 12 month not working as intended - how to?
Thank you for your effort. I have uploaded an excel to OneDrive, here you have it: R12 sample In case we don't come to a solution with the provided file, please let me know and I will do my best to share additional information with you. Looking forward to your response.Re: Rolling 12 month not working as intended - how to?
I edited the [year] slicer's interaction with the visual displaying the rolling 12 month and unabled the interaction and it works as intended (see image below). The down-side with this is you can not only add the measure to visual content in your reports without unabling the interaction to the [year] slicer. That said,if anyone has any suggestions on how to reqrite the DAX to get it working properly without this work-around, I would appreciate your input!
