drilldown help

2 Topics

Drill Down with Custom Message
Hi I have a drill down chart. The x axis has 2 categories - Category and Sub Category. 3 of the Categories do not have a sub category, and the chart is blank when you right click to drill down. When you drill down to the Sub Category, the X axis changes to say (Blank) Sub Category, and the chart is blank. Based on the X axis saying (Blank) Sub Category how can I create a custom message to say 'No data in chart'? I created a card and dropped in a measure. I have tried this measure, but it isn't quite working: No data = if(count(table 1[Count of Sub Category]=0),"No data available","") The syntax half works in that it does display the error message, but it does so on both the Category and Sub Category charts. I only want it to display on the Sub Category charts where they are blank. Does anyone have an idea? Thanks
Solved
Dev-13
4 years ago Place DAX Commands and Tips
450Views
0likes
1Comment
Combo Chart : Drill down and show as table : not showing the %GM correctly
Dear Experts, I am using a combo chart ( Colum + Line) to show the country wise sales and GM%. I have added Accouts as drill down and when i try to click on the 'Show as table' by clicking on 'drill down' button, the % GM is not showing appropriately. Any idea what could be the issue here ? Kindly refer to the pictures below... look at the GM% in the table
KRISH80
5 years ago Place DAX Commands and Tips
380Views
0likes
0Comments