Solved: All possible report filter values in javascript ap...

mikihiir · ‎03-23-2017

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

Eric_Zhang · ‎03-24-2017

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>

View solution in original post

Eric_Zhang · ‎03-24-2017

@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>

mikihiir · ‎03-24-2017

Ok, thanks

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

All possible report filter values in javascript api

Helpful resources

Fabric certifications survey

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024