Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
BACKGROUND:
I have 4 Business Units(BU) and I'm representing the order value of these 4 BU's month wise from Jan to Dec in a table and a line chart.
Now, the value of these BU's change based on Chance parameter which is decided by the sales team for each month.
There are total 4 chance percentages - 25%, 55%, 75% and 100%.
For Jan it might be 25%, for Feb it can be 55% and 25% and for Mar it can be 100% and 75% and it can be all 4 together.
So they require this dynamic values on the dashboard to see what change can occur.
MY WORK:
SO, I have created 4 slicers for every month, each slicer containing this one % value. So, total 4 * 12 (12 months in a year) = 48 slicers.
And created DAX for each month. So for example, based on the selection of this 4 slicers of Jan month, BU values in Jan month will change.
Note : I have used query reduction feature with Apply all button to decrease the loading time.
PROBLEM:
It is working correctly. But 48 slicers on a page doesn't look good visually and it also impacts the loading time.
Any one with some better idea/suggestions to do this thing which would help the dashboard look visually good or provide better optimisation.
Sorry I can't provide the full pbix file because of confidentiality. But I have now attached a snippet now.
Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.
User | Count |
---|---|
76 | |
75 | |
46 | |
31 | |
27 |
User | Count |
---|---|
99 | |
91 | |
51 | |
49 | |
45 |