Forum Discussion

sivarajan21's avatar
sivarajan21
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Field Parameter button selection shows nothing in visual

Hi,   I have 2 field parameters that filters a visual like below: The one field parameter acts as a main and other acts as sub. Main will have only 2 buttons one for target and another for ...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • rbriga's avatar
    rbriga
    2 years ago

    I see the problem.

    You're slicing by the field "Category Main" {budget, target}, but Carbon in the Parameter tables have no "category main".

    Thus, you're filtering "carbon" out.

    You won't even see "carbon' in [actual], because  "Category Main" filters your "Parameter 2" table.

     

    If you're going to slice by "category main', you can't leave that field empty in your parameter tables for "carbon".

     

    It's hard for me to offer a fix because the logic is a little hard to follow, but this is the problem.

     

rbriga's avatar
rbriga
Icon for Impactful Individual rankImpactful Individual
2 years ago
  1. Can you share your measure [Carbon tCO2e] (and any measure it refferences, if any)?
  2. In the same chart, what happens if you replace the parameter with the measure [Carbon tCO2e] itself?

I can't download the .pbix file because of my company's policy, so I'll need more info.

sivarajan21's avatar
sivarajan21
Icon for Post Prodigy rankPost Prodigy
2 years ago

Hi rbriga ,

 

Thanks for your quick response!

Below is the carbon measure used

Carbon tCO2e = SUMX(DataInvoice,DataInvoice[Units]*DataInvoice[Factor])/1000
 
Factor in turn is a calculated column as below:
Factor = calculate(max(Factor[Value]),FILTER(Factor, Factor[StartDate] <= DataInvoice[Date] && Factor[EndDate] >= DataInvoice[Date]),Factor[DBName - Utility]=RELATED(Points[DBName-Utility]))
 
Relationships between calendar and factor is:

Is there any issue with relationship here as they are related tables?

 

with regards to second point, If i drag the carbon  measure to replace the parameter, it will show carbon but Units  & cost will not be displayed.
End goal is to use the parameter to make it dynamic
My confusion is,Actual Units and Actual Cost are showing values in chart visual but carbon only is not showing up: 
Below is the field parameter table for your reference:

 

Please let me know if you need further info!

Thanks in advance!