Forum Discussion
Drilldown by Legend Issue
Hi Anonymous ,
What is happenning is that you are changing the granularity of the axis and of the "steps" of your column chart.
When you use the legend on a stacked column chart, the values in the legends are the several "steps" of your column, so in this case when you have category name you only have two so it returns two "steps" when you go to the week it will show a "step" by each week.
You need to keep the week on the axist and add the next level of detail to this Axis so in this case you select a blue value in a specific week and you get that adittional level of detail.
If this does not give you expected result can you please share a mockup data or sample of your PBIX file and expected reuslt. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Super UserHi Anonymous ,
What is happenning is that you are changing the granularity of the axis and of the "steps" of your column chart.
When you use the legend on a stacked column chart, the values in the legends are the several "steps" of your column, so in this case when you have category name you only have two so it returns two "steps" when you go to the week it will show a "step" by each week.
You need to keep the week on the axist and add the next level of detail to this Axis so in this case you select a blue value in a specific week and you get that adittional level of detail.
If this does not give you expected result can you please share a mockup data or sample of your PBIX file and expected reuslt. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Miguel,
You are an angel! AND I feel stupid. I did not try to just simply add all the drill-downs to the axis (I incorrectly assumed that the drill down categories would replace the week number). Thank you SOOO much!!
-Rob