Hi Chandoo,
I am using Power Pivot to display data to my clients. The data in Power Pivot is coming from Power Query. I have wrote measures to calculate the values from various fields.
Now my client want to control the drill down of Power Pivot. If I clicked on any number (measure value) from values section. then it shows total numbers of rows instead of measure value.
I need to restrict the row count. If I click on any number then the drill down will show rows derived from that measure only.
Is it possible???
I have attached a image. If I clicked on value highlighted in yellow. then the drill down sheet is showing the number of rows shows in Red. I want to restrict rows to the yellow highlighted value.
I am using Power Pivot to display data to my clients. The data in Power Pivot is coming from Power Query. I have wrote measures to calculate the values from various fields.
Now my client want to control the drill down of Power Pivot. If I clicked on any number (measure value) from values section. then it shows total numbers of rows instead of measure value.
I need to restrict the row count. If I click on any number then the drill down will show rows derived from that measure only.
Is it possible???
I have attached a image. If I clicked on value highlighted in yellow. then the drill down sheet is showing the number of rows shows in Red. I want to restrict rows to the yellow highlighted value.