Hello, I have a very specific thing that I want to do within Power bi paginated reports, and I can't seem to find any way of doing it. Specifically, I want to have two separate parameters: a "Project" parameter where the user selects the specific project that they are working on, and then a "Report Number" parameter that has the specific report that the user wants to export, where the available values for the report number parameter change based on the selection of the project I can't seem to find any way of doing this. I can set up the first parameter pretty easily; I just set it up like a normal parameter, but I can't get its selection to edit the available values for the report number parameter. It always shows up with every report number between all projects, along with multiples of the same report number, so basically it isn't filtering the selections available at all. Ideally, what I would want is that when I make a selection with the "Project" parameter, it would limit the possible selections for the "Report Number" to only the report numbers from rows that have the selected project as their parent project, but if thats not possible, just some way of making the report number parameter filter not have duplicate values, and then later, like in the query for the reports, I just use a where clause to refine the query. Thank you!
