Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have an bar graph that shows Quarter -> Month on X-Axis and the user can drill up/down between these two, but when selected "Month" i wanted to show only the "Month" label, not "Quarter + Month" on X-Axis. I already disabled "Concatenate Labels" on "X Axis" option but it doesn't change anything.
My X-Axis look like this when selected "Month", i just wanted to show "08-2021", "07-2021"
Hi @Anonymous ,
If the Quarter is not necessary, you may remove it from X-axis field?
Could you please share me with your pbix file after removing sensitive data to help us clarify your scenario?
Best Regards,
Eyelyn Qin
I'm having problems uploading the .pbix file, it says that its not supported, but i've created a simple example.
Thats my database (date / valor)
And i wanna show, in a bar graph, values for each quarter and drill down for month, but i wanna show only the "month" label on X-Axis when drilling down.
Right now it shows me like this (Quarter + Year + Month)
So, this when looking at quarter:
And this when drill down to month: (month year)
Hi @Anonymous
I think this link can help you:
https://community.powerbi.com/t5/Desktop/X-Axis-Label-Hierarchy/m-p/841928
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos !!
Hey @VahidDM , i already disabled Concatenate labels on "X Axis", but still have Quarter + Month on my visualization. These Quarter and Month are text data type, not date data type, i dont know if this can be a problem.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |