Forum Discussion

Karl_Kvarfordh's avatar
Karl_Kvarfordh
Frequent Visitor
4 years ago
Solved

User defined bins that applies current filter context

Hello!   I have a large model with invoices, spend, categories and supplier names etc.   I would like to create a stacked column chart where I can group the suppliers in user defined bins by spen...
  • Karl_Kvarfordh's avatar
    4 years ago

    Thank you for your answer!

    I was going to upload sample data and expected outcome today but now I found a solution on my own.

    As you answered, I realized that and that there were no dax-workaround to make a calculated column out of a measure


    The solution for me was to work out a way with a small separate table where I could put the user defined bins as a column (and then place it on category-level in a visual) and then work out the number of suppliers in each bins as a measure.

    Pages like this helped me to build my solution: 
    https://radacad.com/dax-measure-in-the-axis-of-the-power-bi-report