Forum Discussion

Jdrien's avatar
Jdrien
Frequent Visitor
2 years ago
Solved

Apply filters on REST API JSON POST request

hello, ​​​​​​​I'm trying to call the powerBI REST api (JSON) i can get the page i want and creat the pdf, but i cant' manage to apply filters, I've created a really simple page for tests (just a s...
"And filter"
"Need Help"
"Power BI Report Server Printing"
  • Jdrien's avatar
    Jdrien
    1 year ago

    Ok i've figured why i had this problem, my segment was set to "one selection" so there was always an item selected, the problem was the api downloaded the report with this selcection, then tried to filter it. i just had to uncheck "only one selection", uncheck everything, save the report, then i could filter my report!
     

fabyx's avatar
fabyx
Frequent Visitor
1 year ago

Hi lbendlin and everyone

I have a question, is there anywhere that I can exclude some visuals from being filtered, 
for example, 
let's say: BOB has 5 restaurent [1,2,3,4,5]

Restaurantincomebooking
1(Nov)1000Nov(5),Dec(7)
2(Nov):500Nov(2),Dec(3)
3Nov:400Nov(1),Dec(2)
4Nov:3000Nov(45),Dec(10)
5Nov: 2000Nov(7),Dec(7)


BOB needs to export Restaurant 1 in November, but for booking, he wants to see ALL(Oct, Dec).

income values show 1000, but for bookings, instead of 5,  it shows 12. 
so using the reportLevelFilter, the filter affects all visuals therefore I was wondering if there is a way to exclude some visuals.

Thank you in advance for the one who can show me the way out

 

regards

Fab

 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

I don't think mixing report level filters and visual interactions is a good idea. But go ahead, try it out.

  • fabyx's avatar
    fabyx
    Frequent Visitor
    1 year ago

    Hallo lbendlin do you by chance know how i can find documentation for visual interaction. i tried using 

     
    pages: [
    {
    pageName: "ReportSection9", 
     visuals: [
      {
          visualName: "f986f3cfa280c2986e82", 
          interactions: [
            {
             value: "M", 
            },
         ],
      },
    ],
    This is not working
    also somthing like this
    pages: [
    {
    pageName: "ReportSection9",
    visuals: [
    {
    visualName: "f986f3cfa280c2986e82",
    filters: [
    {
    filter: `tablename/culumn eq 'M'`,
    overrideDefaultFilters: true,
    },
    ],
    },
    ],
    },
    ],
    but i seem to be wrong, do you have any idea of how i can go around this 

    thanks