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.
Hi experts,
Need your help here.
We have two dates in our dataset, say Order Date and Sales date. Based on the User, we want to change the X-axis of a bar graph. If user wants to see data based on the Sales Date, then X- axis should show sales date and if selected value id Order date, then X- axis should show Order date
Thanks
@Anonymous , you have to create a common date table and join both dates with then and then have measures that use date using userelation, a post that you can have measure slicer
Use relation example: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
measure slicer
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://www.youtube.com/watch?v=vlnx7QUVYME
In case you change axis not date in measure
Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
Hi @amitchandak . Thanks for your response.
This is the data model we have
and the expected output is
Please advise. Thanks
@Anonymous - See if this helps: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-EVERYTHING-measures-axis-legend-titles-chart-types/m-p/1027881#M444
Thanks @Greg_Deckler for your reply.
In our case we have two date dimensions. one is for Sales date and other if Order date.
What i am trying ...
I have created a table like
Then used the 'Select date' column in the slicer and trying to write a DAX logic like-
But it is not allowing me to use Sale Date[Date] and Order Date[Date] in the DAX.
Any idea??
@Anonymous - Well if that is a measure and you are referring to a column, you need to use an aggregation like MAX, MIN, etc. But, to use a measure in that way you generally need to use a disconnected table. In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
Thanks @Greg_Deckler for a quick reply.
In my case, Sale Date[Date] and Order Date[Date] are two date type columns.
So can not apply any aggregate function.
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 |