Questions tagged [drillthrough]

81 questions
0
votes
0 answers

Unable to put measure in drill through to pull correct rows with out table crashing

I have a very larger dataset with 30+ tables used for IT reporting purpose. I'm in the process of writing a KPI report which shows how we are doing around our Customer KPI. A large proportion of these relate to Tickets logged. This report has 6…
0
votes
0 answers

Ability to remove drill through filter using slicer

I need a slicer which will override the drill through filter or even disable it if possible. I have a report where I am using a DAX measure to calculate SUM(Sales) for consumer segment in a card visual. Here's the DAX measure. SalesForConsumer…
0
votes
0 answers

Drill Down Capabilities in Reports

I am looking for a suggestions on technologies, platform, reporting tool or any other information on implementing drill down capabilities within a dashboard. Can I do it in python or google looker or Power BI? Tableau does not seem to be the…
PC-Stats
  • 95
  • 2
  • 9
0
votes
1 answer

How to decide whether to use dimension column or fact measure in Power BI drill through page

I have a page with table. Columns are: Customer name, Sales count, Sales Amt Another page with table. Columns are: YearWeek, Sales count, Sales Amt Another page I want to create for drill through. This has got table with YearWeek, Customer name,…
variable
  • 8,262
  • 9
  • 95
  • 215
0
votes
0 answers

Report Builder - Pass parameter variables (not hardcoded values) in url to a drillthru report

Using Report Builder/Paginated Reports. I have a main report and drillthru report. I want to pass parameter values from the main report to the drillthru report using url. If I hardcode values in the url, it all works. Is it possible to pass the…
0
votes
0 answers

Timeline Slicer DrillDown Power BI

I have a page in my Power BI report with multiple charts having a timeline on the x axis. I would like to be able to switch the timeline between the following (Day, Month, Quarter, Year) using a slicer. For example when I select Month on the slicer,…
Ikzero
  • 3
  • 2
0
votes
0 answers

Drill Through Once a Specific Field is selected from a Visual

I have a Requirement where User wants to leverage Drill Thorugh option by just selecting the field from a Visual. We have different ways to drill-through and thats possible only after selecting a field and doing right click or by adding a Button and…
0
votes
0 answers

Export all drill through values as separate pages

I am new to Power Bi. I have two pages in power bi: first page "Competencies" has a table of competencies that changes by filters (not static) second page "Competency details" So the question is: I want to export this file with all competencies…
0
votes
0 answers

Passing integer parameter to drill-through report

I have a report in SSRS. The report has one string parameter and one integer parameter. Both parameters have default values set up. I have a text box with an Action to the report itself (drill-through report). I tried to pass both parameters to the…
0
votes
1 answer

Java Mondrian: How to DrillThrough in CalculatedMember ? Or set Zeroes instead of empty cells any other way

I'm using Mondrian as the Olap Server to my application written in Java. So, I have a XML schema with a couple of Cubes. ... ... ...
Maxi-Hard
  • 89
  • 4
0
votes
1 answer

Problem interactions graphics when use drillthrough

I run into the following problem: I have a report with several tabs, in one of the tabs there is a table called "Employees" with different filters that alter that table, and other graphics such as "Level of English" that interact with the table…
0
votes
1 answer

Linking to Another Report in Report Builder

I have 2 reports at diffent report pages in Report Builder Server. First one which has my category values from sql database, another has invoice details about those categories. How can i access to invoice details when i click a related category in…
0
votes
1 answer

How to have Drill Through Filters carry through buttons in PowerBI

I have a matrix where I can drill through to another report using the company name variable. On the drill through page, I have buttons linking to other reports and I want the company name filter that was applied in the drill through to still be…
courty340
  • 101
  • 3
  • 16
0
votes
0 answers

Power BI - Understanding Filters in Drill Through from Table

I am trying to build my first drill through report in Power BI. My tables look like this : The data model looks like this: The table in the first report looks like this: This report has slicers and text filters that filter on "Region", "Product…
learner
  • 833
  • 3
  • 13
  • 24
0
votes
1 answer

How to SSRS DrillThrough with multiple rows & multiple parameter

Hi currently i am doing a SSRS Report & i wanna make a drillthrough action may i know how to make drillthrough depends on rows? i had try like this & still not working =SWITCH(ROWNUMBER("ReportDetails")=1 ,"Jan" …