drilldown help
4 TopicsDrill 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? ThanksSolved450Views0likes1CommentTOO_MANY_DRILL_DOWN_OBJECTS ERROR
Hi Everyone!! I have a dashboard that has their autorefresh set up. It use two data set from SAP. The last 2 months when this report try to refresj gave the following error: Underlying error messageOData: Request failed: The remote server returned an error: (400) Bad Request. (Program error in class CL_RSBOLAP_QV_RESULT_SET method : TOO_MANY_DRILL_DOWN_OBJECT I was looking for ideas to fix it. I checked the characteristics and both data set has lest than 8 characteristics each query. Someone know a way how to fix the problem!! I appreciete idea. Best Regards, Sonia899Views0likes1Commenthow to use drill down data role column in another data role column field to pass the data no expand!
Hi Team, Currently, I'm developing one of the custom visual bar chart, which is using with drill down feature named Parent Data role, passing - parent level hierarchical columns. The drill down setup successfully and, it's functionality is working fine. Now, I am creating another data role called Tooltip (Sample) using few or all table data column passing on it. If I use the hierarchical data column on tooltip, its automatically goes to "Expand to next level" that is full parent data role columns shows. So I couldn't use on either on drill down or tooltip not working right. I want to made on both Drill down and tooltip to be work. I checked in one of the visual tool in powerbi ( Treemap ). The two data roles ( Group & Tooltip ) mapped separately and working excellent. So I’m try to build like this, So want necessary thing to add, kindly tell me want to do ! Thanks, Ammy Vijay434Views0likes0CommentsCombo 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 table380Views0likes0Comments