Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to create a so called HeatMap, KPI visual, or conditional formatting based on few criteria. I have tried using many of the custom visuals and one conditional formatting but none came close to what was developed in Tableau. Here is an Excel file
https://drive.google.com/file/d/1ETKndS-2WeboNzhYgh0m6sGB1FdTuNiY/view?usp=sharing
this includes the following:
I appreciate any help/guidance.
Thank You,
Helal
So, that seems like a straight-up Matrix visualization with Month and Week in Columns, nothing in rows and your 2 measures in Values. Then just conditional format your 2 measures.
Greg,
I started on Matrix visual yesterday and tried conditional formatting (CF). So far, I can see that CF only applies to one measure at the time, correct? another words, I can't say in CF that if this year services (Actual) < Last Year services (Budget) then Red other wise Green. As I did some research, this is a feature that Microsoft Power BI developer team are currently working on . Alternatively, I can create a KPI set with the above logic and then do CF. This will work except that it’s not the same as is presented in Tableau where It shows Both Actual and Budget and then applies the color where appropriate. I am sure there should be a work around util CF on multiple measures be available in future updates.
Check out this nifty use of UNICHAR characters here:
I need help to convert a Tableau dashboard to Power BI with exact look and feel. I have tried most of the custom visuals and conditional formatting with no avail so far. Here is an Excel file
https://drive.google.com/open?id=1ETKndS-2WeboNzhYgh0m6sGB1FdTuNiY
that includes:
I appreciate any help/guidance.
Thank You,
Greg,
Looks like Condiotnal formaating (CF) is only on one measure. I need to do CF on two measures this year vs last year. Conditons are if this year services < last year then Red other wise Green. I can't find CF on two or more measures. I created a KPI of -1 (first condition) and 1 second condition. But I need to show the visualization as in Tableau .Any ideas?
Thank you,
Helal
Thank you Greg. I will try that and post the result.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |