Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Changing data structure in Questionnaire data

Hi,    I have a table built around the answers from a customer survey. the data is modelled in a way which makes it difficult to report on. My end goal is to get a stacked column chart that looks l...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous,

    Try this:

     

     

     

    PBIX file is attached.

     

    Best Regards,
    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Icey, 

 

Thanks for you time! Unfortunately this wont work as a final solution as I need to keep the other columns in the table so the slicers will work, I have slicers for [Area:] and [Building Master] and [Start Date]. I should have mentioned this in the original post sorry! 

 

Thanks Dobby

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

I think it works. If it is not what you want, please let me know.

 

 

Best Regards,

Icey