Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Fabric community is now in read-only for platform upgrade. Learn more

Reply
mikihiir
Helper III
Helper III

All possible report filter values in javascript api

Is is possbile to get all possible filter values, i wanted to get values selected and not selected values ?

1 ACCEPTED SOLUTION
Eric_Zhang
Microsoft Employee
Microsoft Employee

@mikihiir

 

Based on my test, we can only get the filter objects as in this wiki, NOT all values.

 

<html>

  <script src="https://microsoft.github.io/PowerBI-JavaScript/demo/node_modules/jquery/dist/jquery.js"></script>

<script src="https://microsoft.github.io/PowerBI-JavaScript/demo/node_modules/powerbi-client/dist/powerbi.js"></script>
     

<script type="text/javascript">
window.onload = function () {
 
var embedConfiguration = {
    type: 'report',
    accessToken: 'exxxxxxxxxxxxxA',
    id: 'c94a6db4-e077-4dde-861a-7c7d22116451',
    embedUrl: 'https://app.powerbi.com/reportEmbed'	 
}; 

var $reportContainer = $('#reportContainer');
 
var report = powerbi.embed($reportContainer.get(0), embedConfiguration);

 var reportPages; 
  

report.on('dataSelected', function(event)
{
var data = event.detail;
		 
         console.log(JSON.stringify(data, null, ' '));
		 
});

report.on('loaded', function(event)
{

report.getFilters().then(function(filters)
    {
         
		
		console.log(filters[0]);
		 
    });
	
    
});
 

}
</script>

<div  id="reportContainer"></div>
</html>

Capture.PNG

View solution in original post

2 REPLIES 2
Eric_Zhang
Microsoft Employee
Microsoft Employee

@mikihiir

 

Based on my test, we can only get the filter objects as in this wiki, NOT all values.

 

<html>

  <script src="https://microsoft.github.io/PowerBI-JavaScript/demo/node_modules/jquery/dist/jquery.js"></script>

<script src="https://microsoft.github.io/PowerBI-JavaScript/demo/node_modules/powerbi-client/dist/powerbi.js"></script>
     

<script type="text/javascript">
window.onload = function () {
 
var embedConfiguration = {
    type: 'report',
    accessToken: 'exxxxxxxxxxxxxA',
    id: 'c94a6db4-e077-4dde-861a-7c7d22116451',
    embedUrl: 'https://app.powerbi.com/reportEmbed'	 
}; 

var $reportContainer = $('#reportContainer');
 
var report = powerbi.embed($reportContainer.get(0), embedConfiguration);

 var reportPages; 
  

report.on('dataSelected', function(event)
{
var data = event.detail;
		 
         console.log(JSON.stringify(data, null, ' '));
		 
});

report.on('loaded', function(event)
{

report.getFilters().then(function(filters)
    {
         
		
		console.log(filters[0]);
		 
    });
	
    
});
 

}
</script>

<div  id="reportContainer"></div>
</html>

Capture.PNG

Ok, thanks

 

Will make a feature request, need all values for my filter controls(filter dropdowns etc.)

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.