Forum Discussion
Excellove15
Feb 29, 2024Iron Contributor
Drag Dax measures into Y-axis of clustered bar chart for getting count of dates
Hi SergeiBaklan ,
We have a table like this below:
Based on few conditions on Invoice/Credit column of this table, we need to count the Date column of this table and use this count for showing the users that this many counts fall under below:
Multiple Invoices
Credit cancels Invoices
Invoice-Credit Value Mismatch
Multiple Credits
expected outcome:
You helped us creating the conditions in the form of Dax measures instead of calculated columns as below:
Based on above conditions, we created a calculated column as below to create the status column but this still causes performance issues:
So we thought of breaking this into small measures each like below although not sure whether it is correct or not!
Now in visual, we are not able to drag these Dax measure on y-axis of the clustered bar chart as shown below:
If you have different ideas/different way to achieve the requirement, please let us know sir
PFA file here PR-419 - Data Coverage RLS ADB (2).pbix
Thanks in advance!
Nope, I have no other ideas. We can't use measures both in X and Y axis's. As for the performance that's only to play with options. Perhaps another calculated table could work, not sure.
Nope, I have no other ideas. We can't use measures both in X and Y axis's. As for the performance that's only to play with options. Perhaps another calculated table could work, not sure.
- Excellove15Iron Contributor