Forum Discussion
rog_bjo
7 years agoRegular Visitor
Monthly values on the same row into column chart
Excuse me for my limited knowledge. I have a large dataset built as follows (simplified): and I have been able to transfer this into a new presentation that looks like this by adding...
- 7 years ago
Hi rog_bjo,
Based on my test, you could refer to below steps:
Unpivot all your month columns in query editor:
Import custom visual from market place and choose the Infographic designer:
Set below format:
You could also download the pbix file to have a view.
Regards,
Daniel He
v-danhe-msft
Microsoft Employee
7 years agoHi rog_bjo,
Based on my test, you could refer to below steps:
Unpivot all your month columns in query editor:
Import custom visual from market place and choose the Infographic designer:
Set below format:
You could also download the pbix file to have a view.
Regards,
Daniel He
- rog_bjo7 years agoRegular Visitor
Hi,
Thank you! Unpivoting the months columns was the solution I was looking for. I have tested on the complete dataset and it is working.
rog_bjo