Forum Discussion

sivarajan21's avatar
sivarajan21
Post 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
Impactful 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
    Post 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!