The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi Folks,
I think i can't be the first one to encounter this problem.
I've got a report, usually based on months, so my x-axis of most visuals is something like 01-22 02-22 etc.
So now if my user selects a single month out of my column Monthname via slicer, all visuals will show a single bar, point and so on.
So, I want to change the x-axis day-based.
For this, I worte two measures:
First, I get the destinct count of my Months for the slicer. If theres only one monthname, count will be one, if there is more than one monthname, it will be another number.
Solved! Go to Solution.
@SammiElPadre , If you need a dynamic axis based on selected values, I doubt that is possible as of now.
You can give a slicer using field parameters: Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
@SammiElPadre , If you need a dynamic axis based on selected values, I doubt that is possible as of now.
You can give a slicer using field parameters: Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Ok, thank you.
BAd news, but then it has to be manual.
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |