Forum Discussion

Excellove15's avatar
Excellove15
Iron Contributor
Feb 29, 2024
Solved

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!

 

 

  • Excellove15 

    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.

  • Excellove15 

    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.

Resources